Dataset info
| Number of variables | 181 |
|---|---|
| Number of observations | 566 |
| Missing cells | 35172 (34.3%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 762.9 KiB |
| Average record size in memory | 1.3 KiB |
Variables types
| Numeric | 69 |
|---|---|
| Categorical | 20 |
| Boolean | 15 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 76 |
| Unsupported | 0 |
Warnings
coligada_mais_antiga_ativa has 267 (47.2%) missing values | Missing |
coligada_mais_antiga_baixada has constant value "nan" | Rejected |
coligada_mais_nova_ativa has 267 (47.2%) missing values | Missing |
coligada_mais_nova_baixada has constant value "nan" | Rejected |
de_indicador_telefone has constant value "BOA" | Rejected |
de_saude_rescencia has constant value "ACIMA DE 1 ANO" | Rejected |
dt_situacao only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
dt_situacao has a high cardinality: 207 distinct values | Warning |
empsetorcensitariofaixarendapopulacao has 70 (12.4%) missing values | Missing |
faturamento_est_coligados has 273 (48.2%) missing values | Missing |
faturamento_est_coligados_gp is highly correlated with faturamento_est_coligados (ρ = 0.96717) | Rejected |
fl_epp has constant value "False" | Rejected |
fl_matriz has constant value "True" | Rejected |
fl_mei has constant value "False" | Rejected |
fl_optante_simei has constant value "False" | Rejected |
grau_instrucao_macro_analfabeto has 449 (79.3%) missing values | Missing |
grau_instrucao_macro_desconhecido has constant value "nan" | Rejected |
grau_instrucao_macro_escolaridade_fundamental has 48 (8.5%) missing values | Missing |
grau_instrucao_macro_escolaridade_superior has 17 (3.0%) missing values | Missing |
idade_acima_de_58 has 61 (10.8%) missing values | Missing |
idade_ate_18 has 351 (62.0%) missing values | Missing |
idade_de_19_a_23 has 94 (16.6%) missing values | Missing |
idade_de_24_a_28 has 17 (3.0%) missing values | Missing |
idade_de_39_a_43 is highly correlated with idade_de_34_a_38 (ρ = 0.95905) | Rejected |
idade_de_44_a_48 is highly correlated with idade_de_39_a_43 (ρ = 0.98342) | Rejected |
idade_de_49_a_53 is highly correlated with idade_de_44_a_48 (ρ = 0.99027) | Rejected |
idade_de_54_a_58 is highly correlated with idade_de_49_a_53 (ρ = 0.98514) | Rejected |
idade_maxima_coligadas is highly correlated with coligada_mais_antiga_ativa (ρ = 0.99911) | Rejected |
idade_maxima_socios has 213 (37.6%) missing values | Missing |
idade_media_coligadas has 267 (47.2%) missing values | Missing |
idade_media_coligadas_ativas is highly correlated with idade_media_coligadas (ρ = 0.9995) | Rejected |
idade_media_coligadas_baixadas has constant value "nan" | Rejected |
idade_media_socios has 213 (37.6%) missing values | Missing |
idade_minima_coligadas is highly correlated with coligada_mais_nova_ativa (ρ = 0.99963) | Rejected |
idade_minima_socios has 213 (37.6%) missing values | Missing |
max_faturamento_est_coligados has 273 (48.2%) missing values | Missing |
max_faturamento_est_coligados_gp is highly correlated with max_faturamento_est_coligados (ρ = 0.94873) | Rejected |
max_filiais_coligados is highly correlated with max_faturamento_est_coligados_gp (ρ = 0.92095) | Rejected |
max_funcionarios_coligados_gp is highly correlated with max_filiais_coligados (ρ = 0.95968) | Rejected |
max_vl_folha_coligados has 332 (58.7%) missing values | Missing |
max_vl_folha_coligados_gp is highly correlated with max_faturamento_est_coligados_gp (ρ = 0.9326) | Rejected |
media_faturamento_est_coligados has 273 (48.2%) missing values | Missing |
media_faturamento_est_coligados_gp is highly correlated with media_faturamento_est_coligados (ρ = 0.97553) | Rejected |
media_filiais_coligados is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.93788) | Rejected |
media_funcionarios_coligados_gp is highly correlated with media_filiais_coligados (ρ = 0.97637) | Rejected |
media_vl_folha_coligados has 332 (58.7%) missing values | Missing |
media_vl_folha_coligados_gp is highly correlated with media_faturamento_est_coligados_gp (ρ = 0.93982) | Rejected |
min_faturamento_est_coligados has 273 (48.2%) missing values | Missing |
min_faturamento_est_coligados_gp is highly correlated with min_faturamento_est_coligados (ρ = 0.94763) | Rejected |
min_filiais_coligados has 413 (73.0%) missing values | Missing |
min_funcionarios_coligados_gp has 93 (16.4%) zeros | Zeros |
min_funcionarios_coligados_gp has 314 (55.5%) missing values | Missing |
min_meses_servicos is highly correlated with meses_ultima_contratacaco (ρ = 0.98348) | Rejected |
min_meses_servicos_all has 35 (6.2%) zeros | Zeros |
min_vl_folha_coligados is highly correlated with media_vl_folha_coligados (ρ = 0.92717) | Rejected |
min_vl_folha_coligados_gp is highly correlated with min_vl_folha_coligados (ρ = 0.95645) | Rejected |
nm_divisao has a high cardinality: 60 distinct values | Warning |
nm_meso_regiao has 70 (12.4%) missing values | Missing |
nm_micro_regiao has a high cardinality: 61 distinct values | Warning |
nm_micro_regiao has 70 (12.4%) missing values | Missing |
qt_admitidos_12meses has 199 (35.2%) zeros | Zeros |
qt_alteracao_socio_180d has constant value "nan" | Rejected |
qt_alteracao_socio_365d has constant value "nan" | Rejected |
qt_alteracao_socio_90d has constant value "nan" | Rejected |
qt_alteracao_socio_total has constant value "nan" | Rejected |
qt_art has 304 (53.7%) missing values | Missing |
qt_coligadas has 267 (47.2%) missing values | Missing |
qt_coligados is highly correlated with qt_coligadas (ρ = 1) | Rejected |
qt_coligados_agropecuaria has 265 (46.8%) zeros | Zeros |
qt_coligados_agropecuaria has 267 (47.2%) missing values | Missing |
qt_coligados_atividade_alto has constant value "0.0" | Rejected |
qt_coligados_atividade_baixo has constant value "0.0" | Rejected |
qt_coligados_atividade_inativo has constant value "0.0" | Rejected |
qt_coligados_atividade_medio has constant value "0.0" | Rejected |
qt_coligados_atividade_mt_baixo has constant value "0.0" | Rejected |
qt_coligados_ativo is highly correlated with qt_coligados (ρ = 0.99984) | Rejected |
qt_coligados_baixada has 267 (47.2%) missing values | Missing |
qt_coligados_ccivil has 220 (38.9%) zeros | Zeros |
qt_coligados_ccivil has 267 (47.2%) missing values | Missing |
qt_coligados_centro has 272 (48.1%) zeros | Zeros |
qt_coligados_centro has 267 (47.2%) missing values | Missing |
qt_coligados_comercio has 152 (26.9%) zeros | Zeros |
qt_coligados_comercio has 267 (47.2%) missing values | Missing |
qt_coligados_epp has constant value "0.0" | Rejected |
qt_coligados_exterior has 267 (47.2%) missing values | Missing |
qt_coligados_inapta has 267 (47.2%) missing values | Missing |
qt_coligados_industria has 211 (37.3%) zeros | Zeros |
qt_coligados_industria has 267 (47.2%) missing values | Missing |
qt_coligados_ltda has 286 (50.5%) zeros | Zeros |
qt_coligados_ltda has 267 (47.2%) missing values | Missing |
qt_coligados_matriz is highly correlated with qt_coligados_ativo (ρ = 0.99904) | Rejected |
qt_coligados_me has constant value "0.0" | Rejected |
qt_coligados_mei has 267 (47.2%) missing values | Missing |
qt_coligados_nordeste has 141 (24.9%) zeros | Zeros |
qt_coligados_nordeste has 267 (47.2%) missing values | Missing |
qt_coligados_norte has 159 (28.1%) zeros | Zeros |
qt_coligados_norte has 267 (47.2%) missing values | Missing |
qt_coligados_nula has constant value "0.0" | Rejected |
qt_coligados_sa is highly correlated with qt_coligados_industria (ρ = 0.92957) | Rejected |
qt_coligados_serviço has 61 (10.8%) zeros | Zeros |
qt_coligados_serviço has 267 (47.2%) missing values | Missing |
qt_coligados_sudeste is highly correlated with qt_coligados_matriz (ρ = 0.92867) | Rejected |
qt_coligados_sul has 287 (50.7%) zeros | Zeros |
qt_coligados_sul has 267 (47.2%) missing values | Missing |
qt_coligados_suspensa has constant value "0.0" | Rejected |
qt_desligados_12meses has 187 (33.0%) zeros | Zeros |
qt_ex_funcionarios is highly correlated with qt_desligados (ρ = 1) | Rejected |
qt_filiais has 270 (47.7%) zeros | Zeros |
qt_funcionarios is highly correlated with idade_de_54_a_58 (ρ = 0.94732) | Rejected |
qt_funcionarios_12meses is highly correlated with qt_funcionarios (ρ = 0.99761) | Rejected |
qt_funcionarios_24meses is highly correlated with qt_funcionarios_12meses (ρ = 0.98334) | Rejected |
qt_funcionarios_coligados has 18 (3.2%) zeros | Zeros |
qt_funcionarios_coligados has 314 (55.5%) missing values | Missing |
qt_funcionarios_coligados_gp is highly correlated with media_filiais_coligados (ρ = 0.90605) | Rejected |
qt_funcionarios_grupo is highly skewed (γ1 = 21.811) | Skewed |
qt_ramos_coligados has 267 (47.2%) missing values | Missing |
qt_regioes_coligados has 267 (47.2%) missing values | Missing |
qt_socios has 184 (32.5%) missing values | Missing |
qt_socios_coligados is highly correlated with qt_coligados_matriz (ρ = 0.96791) | Rejected |
qt_socios_feminino is highly correlated with qt_socios (ρ = 0.98778) | Rejected |
qt_socios_masculino is highly correlated with qt_socios_feminino (ρ = 0.96613) | Rejected |
qt_socios_pep is highly correlated with qt_socios_masculino (ρ = 0.97676) | Rejected |
qt_socios_pf is highly correlated with qt_socios_pep (ρ = 0.9745) | Rejected |
qt_socios_pj has 184 (32.5%) missing values | Missing |
qt_socios_pj_ativos is highly correlated with qt_socios_pj (ρ = 0.96283) | Rejected |
qt_socios_pj_baixados has 515 (91.0%) missing values | Missing |
qt_socios_pj_inaptos has constant value "0.0" | Rejected |
qt_socios_pj_nulos has constant value "0.0" | Rejected |
qt_socios_pj_suspensos has constant value "0.0" | Rejected |
qt_socios_st_regular is highly correlated with qt_socios_pf (ρ = 0.99433) | Rejected |
qt_socios_st_suspensa has constant value "nan" | Rejected |
qt_ufs_coligados has 267 (47.2%) missing values | Missing |
sum_faturamento_estimado_coligadas is highly correlated with faturamento_est_coligados_gp (ρ = 0.96717) | Rejected |
total is highly correlated with qt_funcionarios_24meses (ρ = 0.97843) | Rejected |
total_filiais_coligados is highly correlated with qt_funcionarios_coligados_gp (ρ = 0.92158) | Rejected |
tx_crescimento_12meses has 195 (34.5%) zeros | Zeros |
tx_crescimento_24meses is highly correlated with qt_socios_pep (ρ = 0.96385) | Rejected |
tx_rotatividade has 188 (33.2%) zeros | Zeros |
vl_folha_coligados is highly correlated with qt_funcionarios_coligados (ρ = 0.92165) | Rejected |
vl_folha_coligados_gp is highly correlated with max_vl_folha_coligados_gp (ρ = 0.90572) | Rejected |
vl_frota has 98 (17.3%) missing values | Missing |
vl_idade_maxima_socios_pj has 515 (91.0%) missing values | Missing |
vl_idade_media_socios_pj is highly correlated with vl_idade_maxima_socios_pj (ρ = 0.93323) | Rejected |
vl_idade_minima_socios_pj is highly correlated with vl_idade_media_socios_pj (ρ = 0.92519) | Rejected |
vl_potenc_cons_oleo_gas has 472 (83.4%) missing values | Missing |
vl_total_tancagem is highly correlated with vl_potenc_cons_oleo_gas (ρ = 0.94313) | Rejected |
vl_total_tancagem_grupo has 536 (94.7%) missing values | Missing |
vl_total_veiculos_antt is highly correlated with vl_total_tancagem_grupo (ρ = 0.9644) | Rejected |
vl_total_veiculos_antt_grupo is highly correlated with vl_total_veiculos_antt (ρ = 1) | Rejected |
vl_total_veiculos_leves has 47 (8.3%) zeros | Zeros |
vl_total_veiculos_leves has 76 (13.4%) missing values | Missing |
vl_total_veiculos_leves_grupo is highly correlated with vl_total_veiculos_leves (ρ = 0.95902) | Rejected |
vl_total_veiculos_pesados has 165 (29.2%) zeros | Zeros |
vl_total_veiculos_pesados has 76 (13.4%) missing values | Missing |
vl_total_veiculos_pesados_grupo has 237 (41.9%) zeros | Zeros |
coligada_mais_antiga_ativa
Numeric
| Distinct count | 292 |
|---|---|
| Unique (%) | 51.6% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 299.87 |
|---|---|
| Minimum | 2.7667 |
| Maximum | 1135.2 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.7667 |
|---|---|
| 5-th percentile | 35.37 |
| Q1 | 151.27 |
| Median | 275.47 |
| Q3 | 432.65 |
| 95-th percentile | 630.89 |
| Maximum | 1135.2 |
| Range | 1132.5 |
| Interquartile range | 281.38 |
Descriptive statistics
| Standard deviation | 187.5 |
|---|---|
| Coef of variation | 0.62528 |
| Kurtosis | 0.16843 |
| Mean | 299.87 |
| MAD | 153.49 |
| Skewness | 0.55723 |
| Sum | 89661 |
| Variance | 35156 |
| Memory size | 8.8 KiB |
| Value | Count | Frequency (%) | |
| 500.13 | 2 | 0.4% | |
| 101.83 | 2 | 0.4% | |
| 635.23 | 2 | 0.4% | |
| 438.73 | 2 | 0.4% | |
| 657.87 | 2 | 0.4% | |
| 261.03 | 2 | 0.4% | |
| 186.8 | 2 | 0.4% | |
| 634.5 | 2 | 0.4% | |
| 336.43 | 1 | 0.2% | |
| 361.73 | 1 | 0.2% | |
| Other values (281) | 281 | 49.6% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.7667 | 1 | 0.2% | |
| 5.8 | 1 | 0.2% | |
| 8.9333 | 1 | 0.2% | |
| 11.133 | 1 | 0.2% | |
| 17.133 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1135.2 | 1 | 0.2% | |
| 674.93 | 1 | 0.2% | |
| 657.87 | 2 | 0.4% | |
| 642.67 | 1 | 0.2% | |
| 636.83 | 1 | 0.2% |
coligada_mais_antiga_baixada
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
coligada_mais_nova_ativa
Numeric
| Distinct count | 282 |
|---|---|
| Unique (%) | 49.8% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 86.911 |
|---|---|
| Minimum | 1.5 |
| Maximum | 614 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.5 |
|---|---|
| 5-th percentile | 3.19 |
| Q1 | 21.367 |
| Median | 56.2 |
| Q3 | 116.25 |
| 95-th percentile | 287.9 |
| Maximum | 614 |
| Range | 612.5 |
| Interquartile range | 94.883 |
Descriptive statistics
| Standard deviation | 91.556 |
|---|---|
| Coef of variation | 1.0534 |
| Kurtosis | 4.7987 |
| Mean | 86.911 |
| MAD | 66.987 |
| Skewness | 1.9204 |
| Sum | 25986 |
| Variance | 8382.6 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 56.9 | 2 | 0.4% | |
| 14.567 | 2 | 0.4% | |
| 2.0333 | 2 | 0.4% | |
| 2.7667 | 2 | 0.4% | |
| 237.43 | 2 | 0.4% | |
| 4.8 | 2 | 0.4% | |
| 186.8 | 2 | 0.4% | |
| 47.8 | 2 | 0.4% | |
| 9.4667 | 2 | 0.4% | |
| 17.933 | 2 | 0.4% | |
| Other values (271) | 279 | 49.3% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.5 | 2 | 0.4% | |
| 1.6 | 1 | 0.2% | |
| 1.9667 | 1 | 0.2% | |
| 2.0333 | 2 | 0.4% | |
| 2.4 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 614 | 1 | 0.2% | |
| 424.63 | 1 | 0.2% | |
| 378.13 | 1 | 0.2% | |
| 377.9 | 1 | 0.2% | |
| 368.87 | 1 | 0.2% |
coligada_mais_nova_baixada
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
de_faixa_faturamento_estimado
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | |
|---|---|
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | |
| Other values (3) | 28 |
| Value | Count | Frequency (%) | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 278 | 49.1% | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 202 | 35.7% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 58 | 10.2% | |
| DE R$ 300.000.000,01 A R$ 500.000.000,00 | 15 | 2.7% | |
| DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | 8 | 1.4% | |
| ACIMA DE 1 BILHAO DE REAIS | 5 | 0.9% |
| Max length | 40 |
|---|---|
| Mean length | 38.537 |
| Min length | 26 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_faixa_faturamento_estimado_grupo
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | |
|---|---|
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | |
| Other values (3) | 31 |
| Value | Count | Frequency (%) | |
| DE R$ 10.000.000,01 A R$ 30.000.000,00 | 247 | 43.6% | |
| DE R$ 30.000.000,01 A R$ 100.000.000,00 | 210 | 37.1% | |
| DE R$ 100.000.000,01 A R$ 300.000.000,00 | 78 | 13.8% | |
| DE R$ 300.000.000,01 A R$ 500.000.000,00 | 14 | 2.5% | |
| DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | 9 | 1.6% | |
| ACIMA DE 1 BILHAO DE REAIS | 8 | 1.4% |
| Max length | 40 |
|---|---|
| Mean length | 38.558 |
| Min length | 26 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
de_indicador_telefone
Constant
This variable is constant and should be ignored for analysis
| Constant value | BOA |
|---|
de_natureza_juridica
Categorical
| Distinct count | 26 |
|---|---|
| Unique (%) | 4.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| SOCIEDADE EMPRESARIA LIMITADA | |
|---|---|
| MUNICIPIO | |
| EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA | 31 |
| Other values (23) |
| Value | Count | Frequency (%) | |
| SOCIEDADE EMPRESARIA LIMITADA | 287 | 50.7% | |
| MUNICIPIO | 110 | 19.4% | |
| EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA | 31 | 5.5% | |
| ASSOCIACAO PRIVADA | 21 | 3.7% | |
| SOCIEDADE ANONIMA FECHADA | 21 | 3.7% | |
| ORGAO PUBLICO DO PODER EXECUTIVO ESTADUAL OU DO DISTRITO FEDERAL | 19 | 3.4% | |
| ORGAO PUBLICO DO PODER EXECUTIVO MUNICIPAL | 12 | 2.1% | |
| EMPRESARIO INDIVIDUAL | 10 | 1.8% | |
| SOCIEDADE SIMPLES LIMITADA | 6 | 1.1% | |
| FUNDO PUBLICO | 6 | 1.1% | |
| Other values (16) | 43 | 7.6% |
| Max length | 70 |
|---|---|
| Mean length | 27.896 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_nivel_atividade
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ALTA | |
|---|---|
| MEDIA | 37 |
| BAIXA | 6 |
| Value | Count | Frequency (%) | |
| ALTA | 523 | 92.4% | |
| MEDIA | 37 | 6.5% | |
| BAIXA | 6 | 1.1% |
| Max length | 5 |
|---|---|
| Mean length | 4.076 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
de_ramo
Categorical
| Distinct count | 29 |
|---|---|
| Unique (%) | 5.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| INDUSTRIA DA CONSTRUCAO | 46 |
| COMERCIO VAREJISTA | 46 |
| Other values (26) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | 163 | 28.8% | |
| INDUSTRIA DA CONSTRUCAO | 46 | 8.1% | |
| COMERCIO VAREJISTA | 46 | 8.1% | |
| SERVICOS ADMINISTRATIVOS | 42 | 7.4% | |
| COMERCIO POR ATACADO | 40 | 7.1% | |
| SERVICOS DE EDUCACAO | 33 | 5.8% | |
| QUIMICA-PETROQUIMICA | 27 | 4.8% | |
| SERVICOS DE SAUDE | 25 | 4.4% | |
| TRANSPORTE, ARMAZENAGEM E CORREIO | 25 | 4.4% | |
| COMERCIO E REPARACAO DE VEICULOS | 21 | 3.7% | |
| Other values (19) | 98 | 17.3% |
| Max length | 49 |
|---|---|
| Mean length | 30.048 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
de_saude_rescencia
Constant
This variable is constant and should be ignored for analysis
| Constant value | ACIMA DE 1 ANO |
|---|
de_saude_tributaria
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| VERDE | |
|---|---|
| AZUL | |
| LARANJA | 44 |
| Other values (2) | 12 |
| Value | Count | Frequency (%) | |
| VERDE | 376 | 66.4% | |
| AZUL | 134 | 23.7% | |
| LARANJA | 44 | 7.8% | |
| VERMELHO | 11 | 1.9% | |
| AMARELO | 1 | 0.2% |
| Max length | 8 |
|---|---|
| Mean length | 4.9806 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
dt_situacao
Categorical
| Distinct count | 207 |
|---|---|
| Unique (%) | 36.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2005-11-03 | |
|---|---|
| 2005-08-27 | 36 |
| 2005-09-24 | 32 |
| Other values (204) |
| Value | Count | Frequency (%) | |
| 2005-11-03 | 201 | 35.5% | |
| 2005-08-27 | 36 | 6.4% | |
| 2005-09-24 | 32 | 5.7% | |
| 1998-07-28 | 17 | 3.0% | |
| 2005-10-07 | 8 | 1.4% | |
| 2005-10-14 | 6 | 1.1% | |
| 2004-12-24 | 5 | 0.9% | |
| 2004-12-31 | 5 | 0.9% | |
| 1999-02-27 | 4 | 0.7% | |
| 2005-10-22 | 4 | 0.7% | |
| Other values (197) | 248 | 43.8% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
empsetorcensitariofaixarendapopulacao
Numeric
| Distinct count | 439 |
|---|---|
| Unique (%) | 77.6% |
| Missing (%) | 12.4% |
| Missing (n) | 70 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1722.2 |
|---|---|
| Minimum | 262.9 |
| Maximum | 8467.1 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 262.9 |
|---|---|
| 5-th percentile | 503.25 |
| Q1 | 818.41 |
| Median | 1215.2 |
| Q3 | 2257.7 |
| 95-th percentile | 4802.2 |
| Maximum | 8467.1 |
| Range | 8204.2 |
| Interquartile range | 1439.2 |
Descriptive statistics
| Standard deviation | 1349.3 |
|---|---|
| Coef of variation | 0.78347 |
| Kurtosis | 3.9356 |
| Mean | 1722.2 |
| MAD | 998.78 |
| Skewness | 1.869 |
| Sum | 8.5421e+05 |
| Variance | 1.8206e+06 |
| Memory size | 8.8 KiB |
| Value | Count | Frequency (%) | |
| 1157 | 10 | 1.8% | |
| 2799.8 | 4 | 0.7% | |
| 2286.1 | 3 | 0.5% | |
| 984.57 | 3 | 0.5% | |
| 3321.9 | 3 | 0.5% | |
| 2317.1 | 3 | 0.5% | |
| 1333.1 | 3 | 0.5% | |
| 1723.2 | 3 | 0.5% | |
| 5054.1 | 3 | 0.5% | |
| 2679.5 | 2 | 0.4% | |
| Other values (428) | 459 | 81.1% | |
| (Missing) | 70 | 12.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 262.9 | 1 | 0.2% | |
| 297.41 | 1 | 0.2% | |
| 304.77 | 1 | 0.2% | |
| 340.39 | 1 | 0.2% | |
| 346.02 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8467.1 | 2 | 0.4% | |
| 6721.6 | 1 | 0.2% | |
| 6583.6 | 1 | 0.2% | |
| 6527.2 | 1 | 0.2% | |
| 6498.2 | 1 | 0.2% |
faturamento_est_coligados
Numeric
| Distinct count | 239 |
|---|---|
| Unique (%) | 42.2% |
| Missing (%) | 48.2% |
| Missing (n) | 273 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.9549e+08 |
|---|---|
| Minimum | 1.2364e+05 |
| Maximum | 7.7807e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.2364e+05 |
|---|---|
| 5-th percentile | 2.1e+05 |
| Q1 | 9.3e+05 |
| Median | 7.4801e+06 |
| Q3 | 4.5219e+07 |
| 95-th percentile | 4.8541e+08 |
| Maximum | 7.7807e+09 |
| Range | 7.7806e+09 |
| Interquartile range | 4.4289e+07 |
Descriptive statistics
| Standard deviation | 8.8832e+08 |
|---|---|
| Coef of variation | 4.5441 |
| Kurtosis | 45.406 |
| Mean | 1.9549e+08 |
| MAD | 3.1206e+08 |
| Skewness | 6.5329 |
| Sum | 5.7278e+10 |
| Variance | 7.8912e+17 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 2.1e+05 | 32 | 5.7% | |
| 4.2e+05 | 10 | 1.8% | |
| 6.3e+05 | 5 | 0.9% | |
| 9.3e+05 | 5 | 0.9% | |
| 8.4e+05 | 2 | 0.4% | |
| 3.3364e+05 | 2 | 0.4% | |
| 1.14e+06 | 2 | 0.4% | |
| 1.35e+06 | 2 | 0.4% | |
| 1.2364e+05 | 2 | 0.4% | |
| 1.1127e+06 | 2 | 0.4% | |
| Other values (228) | 229 | 40.5% | |
| (Missing) | 273 | 48.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.2364e+05 | 2 | 0.4% | |
| 1.5455e+05 | 1 | 0.2% | |
| 1.6485e+05 | 1 | 0.2% | |
| 1.8546e+05 | 1 | 0.2% | |
| 2.1e+05 | 32 | 5.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7.7807e+09 | 1 | 0.2% | |
| 7.5599e+09 | 1 | 0.2% | |
| 5.9645e+09 | 1 | 0.2% | |
| 5.223e+09 | 1 | 0.2% | |
| 4.1484e+09 | 1 | 0.2% |
faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.96717 |
|---|
fl_antt
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 92 |
| Value | Count | Frequency (%) | |
| False | 474 | 83.7% | |
| True | 92 | 16.3% |
fl_email
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 304 | 53.7% | |
| True | 262 | 46.3% |
fl_epp
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_ltda
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 4 |
| Value | Count | Frequency (%) | |
| False | 562 | 99.3% | |
| True | 4 | 0.7% |
fl_matriz
Constant
This variable is constant and should be ignored for analysis
| Constant value | True |
|---|
fl_me
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 2 |
| Value | Count | Frequency (%) | |
| False | 564 | 99.6% | |
| True | 2 | 0.4% |
fl_mei
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_optante_simei
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
fl_optante_simples
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 27 |
| Value | Count | Frequency (%) | |
| False | 539 | 95.2% | |
| True | 27 | 4.8% |
fl_passivel_iss
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False | 76 |
| Value | Count | Frequency (%) | |
| True | 490 | 86.6% | |
| False | 76 | 13.4% |
fl_rm
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| SIM | |
|---|---|
| NAO |
| Value | Count | Frequency (%) | |
| SIM | 307 | 54.2% | |
| NAO | 259 | 45.8% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
fl_sa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 23 |
| Value | Count | Frequency (%) | |
| False | 543 | 95.9% | |
| True | 23 | 4.1% |
fl_simples_irregular
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) | |
| False | 565 | 99.8% | |
| True | 1 | 0.2% |
fl_spa
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 27 |
| Value | Count | Frequency (%) | |
| False | 539 | 95.2% | |
| True | 27 | 4.8% |
fl_st_especial
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 2 |
| Value | Count | Frequency (%) | |
| False | 564 | 99.6% | |
| True | 2 | 0.4% |
fl_telefone
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 307 | 54.2% | |
| False | 259 | 45.8% |
fl_veiculo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False | 76 |
| Value | Count | Frequency (%) | |
| True | 490 | 86.6% | |
| False | 76 | 13.4% |
grau_instrucao_macro_analfabeto
Numeric
| Distinct count | 18 |
|---|---|
| Unique (%) | 3.2% |
| Missing (%) | 79.3% |
| Missing (n) | 449 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.1282 |
|---|---|
| Minimum | 1 |
| Maximum | 135 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 5 |
| 95-th percentile | 11.2 |
| Maximum | 135 |
| Range | 134 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 14.434 |
|---|---|
| Coef of variation | 2.8146 |
| Kurtosis | 63.007 |
| Mean | 5.1282 |
| MAD | 5.1694 |
| Skewness | 7.613 |
| Sum | 600 |
| Variance | 208.34 |
| Memory size | 8.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 51 | 9.0% | |
| 2 | 20 | 3.5% | |
| 3 | 11 | 1.9% | |
| 6 | 7 | 1.2% | |
| 4 | 5 | 0.9% | |
| 10 | 4 | 0.7% | |
| 7 | 4 | 0.7% | |
| 9 | 3 | 0.5% | |
| 5 | 2 | 0.4% | |
| 11 | 2 | 0.4% | |
| Other values (7) | 8 | 1.4% | |
| (Missing) | 449 | 79.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 51 | 9.0% | |
| 2 | 20 | 3.5% | |
| 3 | 11 | 1.9% | |
| 4 | 5 | 0.9% | |
| 5 | 2 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 135 | 1 | 0.2% | |
| 80 | 1 | 0.2% | |
| 17 | 1 | 0.2% | |
| 14 | 1 | 0.2% | |
| 13 | 1 | 0.2% |
grau_instrucao_macro_desconhecido
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
grau_instrucao_macro_escolaridade_fundamental
Numeric
| Distinct count | 157 |
|---|---|
| Unique (%) | 27.7% |
| Missing (%) | 8.5% |
| Missing (n) | 48 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 73.212 |
|---|---|
| Minimum | 1 |
| Maximum | 3378 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| Median | 24.5 |
| Q3 | 64.75 |
| 95-th percentile | 268.6 |
| Maximum | 3378 |
| Range | 3377 |
| Interquartile range | 56.75 |
Descriptive statistics
| Standard deviation | 205.92 |
|---|---|
| Coef of variation | 2.8126 |
| Kurtosis | 143.02 |
| Mean | 73.212 |
| MAD | 80.386 |
| Skewness | 10.299 |
| Sum | 37924 |
| Variance | 42403 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 25 | 4.4% | |
| 2 | 24 | 4.2% | |
| 4 | 22 | 3.9% | |
| 3 | 18 | 3.2% | |
| 7 | 17 | 3.0% | |
| 10 | 13 | 2.3% | |
| 6 | 13 | 2.3% | |
| 13 | 13 | 2.3% | |
| 18 | 12 | 2.1% | |
| 9 | 12 | 2.1% | |
| Other values (146) | 349 | 61.7% | |
| (Missing) | 48 | 8.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 25 | 4.4% | |
| 2 | 24 | 4.2% | |
| 3 | 18 | 3.2% | |
| 4 | 22 | 3.9% | |
| 5 | 8 | 1.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3378 | 1 | 0.2% | |
| 1943 | 1 | 0.2% | |
| 1041 | 1 | 0.2% | |
| 971 | 1 | 0.2% | |
| 794 | 1 | 0.2% |
grau_instrucao_macro_escolaridade_media
Numeric
| Distinct count | 268 |
|---|---|
| Unique (%) | 47.3% |
| Missing (%) | 0.5% |
| Missing (n) | 3 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 189.25 |
|---|---|
| Minimum | 1 |
| Maximum | 10413 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 18 |
| Q1 | 48 |
| Median | 78 |
| Q3 | 167.5 |
| 95-th percentile | 547.4 |
| Maximum | 10413 |
| Range | 10412 |
| Interquartile range | 119.5 |
Descriptive statistics
| Standard deviation | 538.65 |
|---|---|
| Coef of variation | 2.8463 |
| Kurtosis | 235.73 |
| Mean | 189.25 |
| MAD | 184.5 |
| Skewness | 13.389 |
| Sum | 1.0655e+05 |
| Variance | 2.9014e+05 |
| Memory size | 8.8 KiB |
| Value | Count | Frequency (%) | |
| 73 | 8 | 1.4% | |
| 51 | 8 | 1.4% | |
| 38 | 8 | 1.4% | |
| 70 | 7 | 1.2% | |
| 55 | 7 | 1.2% | |
| 53 | 7 | 1.2% | |
| 72 | 7 | 1.2% | |
| 59 | 7 | 1.2% | |
| 43 | 7 | 1.2% | |
| 30 | 6 | 1.1% | |
| Other values (257) | 491 | 86.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.2% | |
| 3 | 1 | 0.2% | |
| 4 | 1 | 0.2% | |
| 5 | 2 | 0.4% | |
| 6 | 2 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10413 | 1 | 0.2% | |
| 3256 | 1 | 0.2% | |
| 3054 | 1 | 0.2% | |
| 2447 | 1 | 0.2% | |
| 2387 | 1 | 0.2% |
grau_instrucao_macro_escolaridade_superior
Numeric
| Distinct count | 188 |
|---|---|
| Unique (%) | 33.2% |
| Missing (%) | 3.0% |
| Missing (n) | 17 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 115.98 |
|---|---|
| Minimum | 1 |
| Maximum | 4791 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| Median | 25 |
| Q3 | 85 |
| 95-th percentile | 381.6 |
| Maximum | 4791 |
| Range | 4790 |
| Interquartile range | 77 |
Descriptive statistics
| Standard deviation | 374.66 |
|---|---|
| Coef of variation | 3.2304 |
| Kurtosis | 79.781 |
| Mean | 115.98 |
| MAD | 140.54 |
| Skewness | 8.1075 |
| Sum | 63674 |
| Variance | 1.4037e+05 |
| Memory size | 8.8 KiB |
| Value | Count | Frequency (%) | |
| 3 | 30 | 5.3% | |
| 2 | 27 | 4.8% | |
| 4 | 18 | 3.2% | |
| 7 | 17 | 3.0% | |
| 5 | 16 | 2.8% | |
| 1 | 15 | 2.7% | |
| 6 | 14 | 2.5% | |
| 10 | 12 | 2.1% | |
| 8 | 12 | 2.1% | |
| 12 | 11 | 1.9% | |
| Other values (177) | 377 | 66.6% | |
| (Missing) | 17 | 3.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 15 | 2.7% | |
| 2 | 27 | 4.8% | |
| 3 | 30 | 5.3% | |
| 4 | 18 | 3.2% | |
| 5 | 16 | 2.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4791 | 1 | 0.2% | |
| 4152 | 1 | 0.2% | |
| 2807 | 1 | 0.2% | |
| 2652 | 1 | 0.2% | |
| 2161 | 1 | 0.2% |
id
Categorical, Unique
| First 5 values |
|---|
| 00990ce9e5ed028c985c70d79caf6bfafec0611deacee65001879ae201e5d36b |
| 01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 |
| 01ecafa00e8e543ab9fe828672c4c1ff5737610514c0b8e33b0a49a83f72238c |
| 021ac088e5a7462494d919e7b7b0781e9ae5aa8b6a370b2d65c44345f0ecc857 |
| 021d2faf177f995a2011eb905d14777ec5091106b121a4bdb7f4a6eac5fd978f |
| Last 5 values |
|---|
| ff4ce2406e71e486b19e95137147273a32f8dd218a78d7a5ea0952f135258ef9 |
| ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 |
| ff7a936c109aa9eacb07b9a4817b6358b41221644c2bce37ba76d16469a8982a |
| ffa23f42a6e5d386c5af84a747bdc32d43e632b6ffaaac3ac349c280cae803fd |
| ffeeb8d2494392dc868d636243d3f97ab607b9ca6e200aa897cbd7cb320cf8a2 |
First 5 values
| Value | Count | Frequency (%) | |
| 00990ce9e5ed028c985c70d79caf6bfafec0611deacee65001879ae201e5d36b | 1 | 0.2% | |
| 01a586fca9efeab9f83ccab019962b0887882fac2625fe8363da97276c25e0f2 | 1 | 0.2% | |
| 01ecafa00e8e543ab9fe828672c4c1ff5737610514c0b8e33b0a49a83f72238c | 1 | 0.2% | |
| 021ac088e5a7462494d919e7b7b0781e9ae5aa8b6a370b2d65c44345f0ecc857 | 1 | 0.2% | |
| 021d2faf177f995a2011eb905d14777ec5091106b121a4bdb7f4a6eac5fd978f | 1 | 0.2% |
Last 5 values
| Value | Count | Frequency (%) | |
| ffeeb8d2494392dc868d636243d3f97ab607b9ca6e200aa897cbd7cb320cf8a2 | 1 | 0.2% | |
| ffa23f42a6e5d386c5af84a747bdc32d43e632b6ffaaac3ac349c280cae803fd | 1 | 0.2% | |
| ff7a936c109aa9eacb07b9a4817b6358b41221644c2bce37ba76d16469a8982a | 1 | 0.2% | |
| ff6f9b8c9ff446342c06e6a858e9589e708412ffd409b3ff71d663ecf8761bc6 | 1 | 0.2% | |
| ff4ce2406e71e486b19e95137147273a32f8dd218a78d7a5ea0952f135258ef9 | 1 | 0.2% |
idade_acima_de_58
Numeric
| Distinct count | 100 |
|---|---|
| Unique (%) | 17.7% |
| Missing (%) | 10.8% |
| Missing (n) | 61 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 40.749 |
|---|---|
| Minimum | 1 |
| Maximum | 3663 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 8 |
| Q3 | 23 |
| 95-th percentile | 117 |
| Maximum | 3663 |
| Range | 3662 |
| Interquartile range | 20 |
Descriptive statistics
| Standard deviation | 203.01 |
|---|---|
| Coef of variation | 4.982 |
| Kurtosis | 218.01 |
| Mean | 40.749 |
| MAD | 52.517 |
| Skewness | 13.587 |
| Sum | 20578 |
| Variance | 41213 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 2 | 55 | 9.7% | |
| 1 | 55 | 9.7% | |
| 5 | 38 | 6.7% | |
| 3 | 32 | 5.7% | |
| 4 | 31 | 5.5% | |
| 7 | 21 | 3.7% | |
| 6 | 20 | 3.5% | |
| 8 | 17 | 3.0% | |
| 9 | 14 | 2.5% | |
| 11 | 13 | 2.3% | |
| Other values (89) | 209 | 36.9% | |
| (Missing) | 61 | 10.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 55 | 9.7% | |
| 2 | 55 | 9.7% | |
| 3 | 32 | 5.7% | |
| 4 | 31 | 5.5% | |
| 5 | 38 | 6.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3663 | 1 | 0.2% | |
| 1844 | 1 | 0.2% | |
| 1401 | 1 | 0.2% | |
| 906 | 1 | 0.2% | |
| 674 | 1 | 0.2% |
idade_ate_18
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | 2.7% |
| Missing (%) | 62.0% |
| Missing (n) | 351 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.4558 |
|---|---|
| Minimum | 1 |
| Maximum | 83 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 3.5 |
| 95-th percentile | 7 |
| Maximum | 83 |
| Range | 82 |
| Interquartile range | 2.5 |
Descriptive statistics
| Standard deviation | 7.1615 |
|---|---|
| Coef of variation | 2.0723 |
| Kurtosis | 85.449 |
| Mean | 3.4558 |
| MAD | 2.6082 |
| Skewness | 8.6671 |
| Sum | 743 |
| Variance | 51.287 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 78 | 13.8% | |
| 2 | 51 | 9.0% | |
| 3 | 32 | 5.7% | |
| 4 | 14 | 2.5% | |
| 6 | 13 | 2.3% | |
| 5 | 11 | 1.9% | |
| 7 | 6 | 1.1% | |
| 8 | 3 | 0.5% | |
| 9 | 2 | 0.4% | |
| 10 | 1 | 0.2% | |
| Other values (4) | 4 | 0.7% | |
| (Missing) | 351 | 62.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 78 | 13.8% | |
| 2 | 51 | 9.0% | |
| 3 | 32 | 5.7% | |
| 4 | 14 | 2.5% | |
| 5 | 11 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 83 | 1 | 0.2% | |
| 56 | 1 | 0.2% | |
| 33 | 1 | 0.2% | |
| 12 | 1 | 0.2% | |
| 10 | 1 | 0.2% |
idade_de_19_a_23
Numeric
| Distinct count | 72 |
|---|---|
| Unique (%) | 12.7% |
| Missing (%) | 16.6% |
| Missing (n) | 94 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 18.307 |
|---|---|
| Minimum | 1 |
| Maximum | 643 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| Median | 9 |
| Q3 | 16.25 |
| 95-th percentile | 56.45 |
| Maximum | 643 |
| Range | 642 |
| Interquartile range | 13.25 |
Descriptive statistics
| Standard deviation | 45.5 |
|---|---|
| Coef of variation | 2.4854 |
| Kurtosis | 91.846 |
| Mean | 18.307 |
| MAD | 17.735 |
| Skewness | 8.433 |
| Sum | 8641 |
| Variance | 2070.3 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 52 | 9.2% | |
| 2 | 38 | 6.7% | |
| 3 | 35 | 6.2% | |
| 4 | 25 | 4.4% | |
| 5 | 25 | 4.4% | |
| 8 | 24 | 4.2% | |
| 9 | 21 | 3.7% | |
| 11 | 20 | 3.5% | |
| 6 | 20 | 3.5% | |
| 10 | 17 | 3.0% | |
| Other values (61) | 195 | 34.5% | |
| (Missing) | 94 | 16.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 52 | 9.2% | |
| 2 | 38 | 6.7% | |
| 3 | 35 | 6.2% | |
| 4 | 25 | 4.4% | |
| 5 | 25 | 4.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 643 | 1 | 0.2% | |
| 373 | 1 | 0.2% | |
| 323 | 1 | 0.2% | |
| 286 | 1 | 0.2% | |
| 253 | 1 | 0.2% |
idade_de_24_a_28
Numeric
| Distinct count | 107 |
|---|---|
| Unique (%) | 18.9% |
| Missing (%) | 3.0% |
| Missing (n) | 17 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 33.137 |
|---|---|
| Minimum | 1 |
| Maximum | 949 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 9 |
| Median | 17 |
| Q3 | 31 |
| 95-th percentile | 101.8 |
| Maximum | 949 |
| Range | 948 |
| Interquartile range | 22 |
Descriptive statistics
| Standard deviation | 66.397 |
|---|---|
| Coef of variation | 2.0037 |
| Kurtosis | 83.925 |
| Mean | 33.137 |
| MAD | 29.786 |
| Skewness | 7.76 |
| Sum | 18192 |
| Variance | 4408.6 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 6 | 25 | 4.4% | |
| 12 | 22 | 3.9% | |
| 9 | 21 | 3.7% | |
| 7 | 20 | 3.5% | |
| 8 | 20 | 3.5% | |
| 15 | 20 | 3.5% | |
| 10 | 19 | 3.4% | |
| 21 | 19 | 3.4% | |
| 11 | 19 | 3.4% | |
| 17 | 17 | 3.0% | |
| Other values (96) | 347 | 61.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 11 | 1.9% | |
| 2 | 11 | 1.9% | |
| 3 | 15 | 2.7% | |
| 4 | 16 | 2.8% | |
| 5 | 13 | 2.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 949 | 1 | 0.2% | |
| 631 | 1 | 0.2% | |
| 486 | 1 | 0.2% | |
| 376 | 1 | 0.2% | |
| 359 | 1 | 0.2% |
idade_de_29_a_33
Numeric
| Distinct count | 136 |
|---|---|
| Unique (%) | 24.0% |
| Missing (%) | 0.7% |
| Missing (n) | 4 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 49.623 |
|---|---|
| Minimum | 1 |
| Maximum | 785 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7.05 |
| Q1 | 14 |
| Median | 23 |
| Q3 | 45 |
| 95-th percentile | 169.8 |
| Maximum | 785 |
| Range | 784 |
| Interquartile range | 31 |
Descriptive statistics
| Standard deviation | 87.526 |
|---|---|
| Coef of variation | 1.7638 |
| Kurtosis | 30.979 |
| Mean | 49.623 |
| MAD | 44.244 |
| Skewness | 5.0723 |
| Sum | 27888 |
| Variance | 7660.8 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 16 | 24 | 4.2% | |
| 9 | 22 | 3.9% | |
| 12 | 21 | 3.7% | |
| 15 | 21 | 3.7% | |
| 18 | 20 | 3.5% | |
| 13 | 19 | 3.4% | |
| 10 | 19 | 3.4% | |
| 19 | 17 | 3.0% | |
| 26 | 15 | 2.7% | |
| 8 | 15 | 2.7% | |
| Other values (125) | 369 | 65.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.2% | |
| 2 | 4 | 0.7% | |
| 3 | 3 | 0.5% | |
| 4 | 5 | 0.9% | |
| 5 | 4 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 785 | 1 | 0.2% | |
| 749 | 1 | 0.2% | |
| 714 | 1 | 0.2% | |
| 580 | 1 | 0.2% | |
| 559 | 1 | 0.2% |
idade_de_34_a_38
Numeric
| Distinct count | 148 |
|---|---|
| Unique (%) | 26.1% |
| Missing (%) | 0.2% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 59.08 |
|---|---|
| Minimum | 1 |
| Maximum | 1884 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 15 |
| Median | 25 |
| Q3 | 49 |
| 95-th percentile | 178.4 |
| Maximum | 1884 |
| Range | 1883 |
| Interquartile range | 34 |
Descriptive statistics
| Standard deviation | 128.65 |
|---|---|
| Coef of variation | 2.1775 |
| Kurtosis | 87.798 |
| Mean | 59.08 |
| MAD | 56.537 |
| Skewness | 7.9617 |
| Sum | 33380 |
| Variance | 16550 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 16 | 20 | 3.5% | |
| 13 | 19 | 3.4% | |
| 11 | 19 | 3.4% | |
| 21 | 18 | 3.2% | |
| 14 | 18 | 3.2% | |
| 10 | 17 | 3.0% | |
| 20 | 15 | 2.7% | |
| 17 | 15 | 2.7% | |
| 22 | 14 | 2.5% | |
| 12 | 14 | 2.5% | |
| Other values (137) | 396 | 70.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 2 | 0.4% | |
| 3 | 5 | 0.9% | |
| 4 | 1 | 0.2% | |
| 5 | 5 | 0.9% | |
| 6 | 8 | 1.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1884 | 1 | 0.2% | |
| 1047 | 1 | 0.2% | |
| 1027 | 1 | 0.2% | |
| 923 | 1 | 0.2% | |
| 620 | 1 | 0.2% |
idade_de_39_a_43
Highly correlated
This variable is highly correlated with idade_de_34_a_38 and should be ignored for analysis
| Correlation | 0.95905 |
|---|
idade_de_44_a_48
Highly correlated
This variable is highly correlated with idade_de_39_a_43 and should be ignored for analysis
| Correlation | 0.98342 |
|---|
idade_de_49_a_53
Highly correlated
This variable is highly correlated with idade_de_44_a_48 and should be ignored for analysis
| Correlation | 0.99027 |
|---|
idade_de_54_a_58
Highly correlated
This variable is highly correlated with idade_de_49_a_53 and should be ignored for analysis
| Correlation | 0.98514 |
|---|
idade_emp_cat
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| > 20 | |
|---|---|
| 10 a 15 | |
| 15 a 20 |
| Value | Count | Frequency (%) | |
| > 20 | 379 | 67.0% | |
| 10 a 15 | 98 | 17.3% | |
| 15 a 20 | 89 | 15.7% |
| Max length | 7 |
|---|---|
| Mean length | 4.9912 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
idade_empresa_anos
Numeric
| Distinct count | 486 |
|---|---|
| Unique (%) | 85.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 26.988 |
|---|---|
| Minimum | 10.038 |
| Maximum | 55.126 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 10.038 |
|---|---|
| 5-th percentile | 11.737 |
| Q1 | 17.832 |
| Median | 23.403 |
| Q3 | 38.628 |
| 95-th percentile | 45.099 |
| Maximum | 55.126 |
| Range | 45.088 |
| Interquartile range | 20.796 |
Descriptive statistics
| Standard deviation | 11.638 |
|---|---|
| Coef of variation | 0.43125 |
| Kurtosis | -1.0421 |
| Mean | 26.988 |
| MAD | 10.014 |
| Skewness | 0.4655 |
| Sum | 15275 |
| Variance | 135.45 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 21.836 | 16 | 2.8% | |
| 43.855 | 14 | 2.5% | |
| 43.866 | 10 | 1.8% | |
| 21.833 | 7 | 1.2% | |
| 43.877 | 6 | 1.1% | |
| 43.868 | 5 | 0.9% | |
| 43.8 | 3 | 0.5% | |
| 21.816 | 3 | 0.5% | |
| 26.362 | 2 | 0.4% | |
| 18.512 | 2 | 0.4% | |
| Other values (476) | 498 | 88.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 10.038 | 1 | 0.2% | |
| 10.066 | 1 | 0.2% | |
| 10.285 | 1 | 0.2% | |
| 10.323 | 1 | 0.2% | |
| 10.364 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 55.126 | 1 | 0.2% | |
| 52.274 | 1 | 0.2% | |
| 52.137 | 1 | 0.2% | |
| 52.036 | 1 | 0.2% | |
| 51.852 | 1 | 0.2% |
idade_maxima_coligadas
Highly correlated
This variable is highly correlated with coligada_mais_antiga_ativa and should be ignored for analysis
| Correlation | 0.99911 |
|---|
idade_maxima_socios
Numeric
| Distinct count | 62 |
|---|---|
| Unique (%) | 11.0% |
| Missing (%) | 37.6% |
| Missing (n) | 213 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 57.609 |
|---|---|
| Minimum | 20 |
| Maximum | 90 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 35.6 |
| Q1 | 49 |
| Median | 59 |
| Q3 | 66 |
| 95-th percentile | 78 |
| Maximum | 90 |
| Range | 70 |
| Interquartile range | 17 |
Descriptive statistics
| Standard deviation | 12.817 |
|---|---|
| Coef of variation | 0.22249 |
| Kurtosis | -0.24842 |
| Mean | 57.609 |
| MAD | 10.337 |
| Skewness | -0.048472 |
| Sum | 20336 |
| Variance | 164.28 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 59 | 17 | 3.0% | |
| 61 | 16 | 2.8% | |
| 52 | 14 | 2.5% | |
| 57 | 13 | 2.3% | |
| 65 | 12 | 2.1% | |
| 54 | 12 | 2.1% | |
| 64 | 12 | 2.1% | |
| 55 | 12 | 2.1% | |
| 68 | 11 | 1.9% | |
| 66 | 10 | 1.8% | |
| Other values (51) | 224 | 39.6% | |
| (Missing) | 213 | 37.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 20 | 1 | 0.2% | |
| 28 | 1 | 0.2% | |
| 29 | 1 | 0.2% | |
| 30 | 2 | 0.4% | |
| 31 | 3 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 90 | 3 | 0.5% | |
| 89 | 1 | 0.2% | |
| 86 | 1 | 0.2% | |
| 84 | 2 | 0.4% | |
| 83 | 2 | 0.4% |
idade_media_coligadas
Numeric
| Distinct count | 300 |
|---|---|
| Unique (%) | 53.0% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 174.32 |
|---|---|
| Minimum | 2.7667 |
| Maximum | 615.18 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.7667 |
|---|---|
| 5-th percentile | 35.37 |
| Q1 | 98.146 |
| Median | 156.06 |
| Q3 | 234.78 |
| 95-th percentile | 367.69 |
| Maximum | 615.18 |
| Range | 612.42 |
| Interquartile range | 136.63 |
Descriptive statistics
| Standard deviation | 105.31 |
|---|---|
| Coef of variation | 0.60415 |
| Kurtosis | 1.0267 |
| Mean | 174.32 |
| MAD | 83.184 |
| Skewness | 0.92416 |
| Sum | 52121 |
| Variance | 11091 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 82.72 | 1 | 0.2% | |
| 194.17 | 1 | 0.2% | |
| 247.94 | 1 | 0.2% | |
| 128.69 | 1 | 0.2% | |
| 191.47 | 1 | 0.2% | |
| 245.22 | 1 | 0.2% | |
| 75.467 | 1 | 0.2% | |
| 189 | 1 | 0.2% | |
| 71.462 | 1 | 0.2% | |
| 161.37 | 1 | 0.2% | |
| Other values (289) | 289 | 51.1% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.7667 | 1 | 0.2% | |
| 5.8 | 1 | 0.2% | |
| 8.9333 | 1 | 0.2% | |
| 9.4667 | 1 | 0.2% | |
| 13.65 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 615.18 | 1 | 0.2% | |
| 504.69 | 1 | 0.2% | |
| 495.95 | 1 | 0.2% | |
| 488.5 | 1 | 0.2% | |
| 444.53 | 1 | 0.2% |
idade_media_coligadas_ativas
Highly correlated
This variable is highly correlated with idade_media_coligadas and should be ignored for analysis
| Correlation | 0.9995 |
|---|
idade_media_coligadas_baixadas
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
idade_media_socios
Numeric
| Distinct count | 144 |
|---|---|
| Unique (%) | 25.4% |
| Missing (%) | 37.6% |
| Missing (n) | 213 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 51.557 |
|---|---|
| Minimum | 20 |
| Maximum | 90 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 33.5 |
| Q1 | 44 |
| Median | 51.5 |
| Q3 | 58.5 |
| 95-th percentile | 69.4 |
| Maximum | 90 |
| Range | 70 |
| Interquartile range | 14.5 |
Descriptive statistics
| Standard deviation | 11.068 |
|---|---|
| Coef of variation | 0.21468 |
| Kurtosis | 0.3014 |
| Mean | 51.557 |
| MAD | 8.7733 |
| Skewness | 0.24258 |
| Sum | 18199 |
| Variance | 122.5 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 52 | 11 | 1.9% | |
| 47 | 9 | 1.6% | |
| 54 | 8 | 1.4% | |
| 46 | 8 | 1.4% | |
| 43.5 | 8 | 1.4% | |
| 50 | 8 | 1.4% | |
| 59 | 7 | 1.2% | |
| 56.5 | 7 | 1.2% | |
| 56 | 7 | 1.2% | |
| 44 | 7 | 1.2% | |
| Other values (133) | 273 | 48.2% | |
| (Missing) | 213 | 37.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 20 | 1 | 0.2% | |
| 27 | 2 | 0.4% | |
| 28 | 1 | 0.2% | |
| 29 | 1 | 0.2% | |
| 29.5 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 90 | 2 | 0.4% | |
| 80.143 | 1 | 0.2% | |
| 79 | 2 | 0.4% | |
| 78 | 1 | 0.2% | |
| 76.5 | 1 | 0.2% |
idade_minima_coligadas
Highly correlated
This variable is highly correlated with coligada_mais_nova_ativa and should be ignored for analysis
| Correlation | 0.99963 |
|---|
idade_minima_socios
Numeric
| Distinct count | 62 |
|---|---|
| Unique (%) | 11.0% |
| Missing (%) | 37.6% |
| Missing (n) | 213 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 46.028 |
|---|---|
| Minimum | 12 |
| Maximum | 90 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 25.6 |
| Q1 | 36 |
| Median | 46 |
| Q3 | 55 |
| 95-th percentile | 68 |
| Maximum | 90 |
| Range | 78 |
| Interquartile range | 19 |
Descriptive statistics
| Standard deviation | 13.071 |
|---|---|
| Coef of variation | 0.28398 |
| Kurtosis | -0.077736 |
| Mean | 46.028 |
| MAD | 10.693 |
| Skewness | 0.27433 |
| Sum | 16248 |
| Variance | 170.86 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 54 | 14 | 2.5% | |
| 34 | 13 | 2.3% | |
| 52 | 13 | 2.3% | |
| 36 | 12 | 2.1% | |
| 46 | 12 | 2.1% | |
| 57 | 12 | 2.1% | |
| 41 | 11 | 1.9% | |
| 39 | 11 | 1.9% | |
| 35 | 11 | 1.9% | |
| 50 | 11 | 1.9% | |
| Other values (51) | 233 | 41.2% | |
| (Missing) | 213 | 37.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 12 | 1 | 0.2% | |
| 19 | 1 | 0.2% | |
| 20 | 1 | 0.2% | |
| 21 | 2 | 0.4% | |
| 22 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 90 | 2 | 0.4% | |
| 79 | 1 | 0.2% | |
| 78 | 1 | 0.2% | |
| 76 | 2 | 0.4% | |
| 75 | 1 | 0.2% |
max_faturamento_est_coligados
Numeric
| Distinct count | 200 |
|---|---|
| Unique (%) | 35.3% |
| Missing (%) | 48.2% |
| Missing (n) | 273 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.1648e+08 |
|---|---|
| Minimum | 1.2364e+05 |
| Maximum | 5.9628e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.2364e+05 |
|---|---|
| 5-th percentile | 2.1e+05 |
| Q1 | 7.4183e+05 |
| Median | 5.4401e+06 |
| Q3 | 2.9982e+07 |
| 95-th percentile | 2.3008e+08 |
| Maximum | 5.9628e+09 |
| Range | 5.9627e+09 |
| Interquartile range | 2.924e+07 |
Descriptive statistics
| Standard deviation | 5.782e+08 |
|---|---|
| Coef of variation | 4.9639 |
| Kurtosis | 62.629 |
| Mean | 1.1648e+08 |
| MAD | 1.8406e+08 |
| Skewness | 7.5526 |
| Sum | 3.4129e+10 |
| Variance | 3.3431e+17 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 2.1e+05 | 52 | 9.2% | |
| 9.3e+05 | 16 | 2.8% | |
| 7.4183e+05 | 4 | 0.7% | |
| 1.1127e+06 | 4 | 0.7% | |
| 3.7092e+05 | 3 | 0.5% | |
| 2.8437e+06 | 2 | 0.4% | |
| 9.8911e+05 | 2 | 0.4% | |
| 1.7412e+07 | 2 | 0.4% | |
| 1.2364e+06 | 2 | 0.4% | |
| 4.451e+07 | 2 | 0.4% | |
| Other values (189) | 204 | 36.0% | |
| (Missing) | 273 | 48.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.2364e+05 | 2 | 0.4% | |
| 1.5455e+05 | 1 | 0.2% | |
| 1.6485e+05 | 1 | 0.2% | |
| 1.8546e+05 | 1 | 0.2% | |
| 2.1e+05 | 52 | 9.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5.9628e+09 | 1 | 0.2% | |
| 5.151e+09 | 1 | 0.2% | |
| 3.7745e+09 | 1 | 0.2% | |
| 2.9397e+09 | 1 | 0.2% | |
| 2.1245e+09 | 1 | 0.2% |
max_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with max_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.94873 |
|---|
max_filiais_coligados
Highly correlated
This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis
| Correlation | 0.92095 |
|---|
max_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with max_filiais_coligados and should be ignored for analysis
| Correlation | 0.95968 |
|---|
max_meses_servicos
Numeric
| Distinct count | 447 |
|---|---|
| Unique (%) | 79.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 339.44 |
|---|---|
| Minimum | 7.6 |
| Maximum | 5099.1 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 7.6 |
|---|---|
| 5-th percentile | 84.825 |
| Q1 | 156.07 |
| Median | 256.02 |
| Q3 | 438.92 |
| 95-th percentile | 584.43 |
| Maximum | 5099.1 |
| Range | 5091.5 |
| Interquartile range | 282.85 |
Descriptive statistics
| Standard deviation | 519.33 |
|---|---|
| Coef of variation | 1.53 |
| Kurtosis | 72.727 |
| Mean | 339.44 |
| MAD | 200.36 |
| Skewness | 8.1902 |
| Sum | 1.9212e+05 |
| Variance | 2.6971e+05 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 265.63 | 7 | 1.2% | |
| 5099.1 | 6 | 1.1% | |
| 265.67 | 5 | 0.9% | |
| 470.67 | 5 | 0.9% | |
| 253.47 | 5 | 0.9% | |
| 507.2 | 5 | 0.9% | |
| 236.3 | 4 | 0.7% | |
| 545.7 | 4 | 0.7% | |
| 92.233 | 4 | 0.7% | |
| 201.8 | 4 | 0.7% | |
| Other values (437) | 517 | 91.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 7.6 | 1 | 0.2% | |
| 21.133 | 1 | 0.2% | |
| 24.2 | 1 | 0.2% | |
| 29.6 | 1 | 0.2% | |
| 30.333 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5099.1 | 6 | 1.1% | |
| 727 | 1 | 0.2% | |
| 717.6 | 1 | 0.2% | |
| 707.37 | 1 | 0.2% | |
| 706 | 1 | 0.2% |
max_meses_servicos_all
Numeric
| Distinct count | 383 |
|---|---|
| Unique (%) | 67.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1420.1 |
|---|---|
| Minimum | 7.6 |
| Maximum | 5099.1 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 7.6 |
|---|---|
| 5-th percentile | 94.125 |
| Q1 | 176.38 |
| Median | 284.05 |
| Q3 | 626.35 |
| 95-th percentile | 5039.3 |
| Maximum | 5099.1 |
| Range | 5091.5 |
| Interquartile range | 449.97 |
Descriptive statistics
| Standard deviation | 2053.6 |
|---|---|
| Coef of variation | 1.4461 |
| Kurtosis | -0.5809 |
| Mean | 1420.1 |
| MAD | 1758.9 |
| Skewness | 1.1844 |
| Sum | 8.0376e+05 |
| Variance | 4.2172e+06 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 5015 | 102 | 18.0% | |
| 5064.7 | 18 | 3.2% | |
| 5099.1 | 6 | 1.1% | |
| 5039.3 | 5 | 0.9% | |
| 5027.2 | 4 | 0.7% | |
| 201.8 | 4 | 0.7% | |
| 265.63 | 4 | 0.7% | |
| 253.47 | 3 | 0.5% | |
| 254.53 | 3 | 0.5% | |
| 168.2 | 3 | 0.5% | |
| Other values (373) | 414 | 73.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 7.6 | 1 | 0.2% | |
| 21.2 | 1 | 0.2% | |
| 24.2 | 1 | 0.2% | |
| 29.6 | 1 | 0.2% | |
| 38.433 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5099.1 | 6 | 1.1% | |
| 5065.7 | 2 | 0.4% | |
| 5064.7 | 18 | 3.2% | |
| 5039.3 | 5 | 0.9% | |
| 5027.2 | 4 | 0.7% |
max_vl_folha_coligados
Numeric
| Distinct count | 188 |
|---|---|
| Unique (%) | 33.2% |
| Missing (%) | 58.7% |
| Missing (n) | 332 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.7944e+07 |
|---|---|
| Minimum | 61819 |
| Maximum | 3.5404e+08 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 61819 |
|---|---|
| 5-th percentile | 1.2364e+05 |
| Q1 | 8.8608e+05 |
| Median | 4.0492e+06 |
| Q3 | 1.223e+07 |
| 95-th percentile | 8.0761e+07 |
| Maximum | 3.5404e+08 |
| Range | 3.5398e+08 |
| Interquartile range | 1.1344e+07 |
Descriptive statistics
| Standard deviation | 4.5464e+07 |
|---|---|
| Coef of variation | 2.5336 |
| Kurtosis | 25.193 |
| Mean | 1.7944e+07 |
| MAD | 2.2338e+07 |
| Skewness | 4.7056 |
| Sum | 4.1989e+09 |
| Variance | 2.067e+15 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 61819 | 9 | 1.6% | |
| 2.4728e+05 | 5 | 0.9% | |
| 5.5637e+05 | 4 | 0.7% | |
| 1.2364e+05 | 3 | 0.5% | |
| 3.7092e+05 | 3 | 0.5% | |
| 1.4424e+05 | 3 | 0.5% | |
| 1.257e+06 | 3 | 0.5% | |
| 6.1819e+05 | 3 | 0.5% | |
| 1.8546e+05 | 3 | 0.5% | |
| 1.6959e+07 | 2 | 0.4% | |
| Other values (177) | 196 | 34.6% | |
| (Missing) | 332 | 58.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 61819 | 9 | 1.6% | |
| 82426 | 1 | 0.2% | |
| 1.0303e+05 | 1 | 0.2% | |
| 1.2364e+05 | 3 | 0.5% | |
| 1.4424e+05 | 3 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.5404e+08 | 1 | 0.2% | |
| 3.1303e+08 | 1 | 0.2% | |
| 2.4398e+08 | 1 | 0.2% | |
| 2.0771e+08 | 1 | 0.2% | |
| 2.0392e+08 | 1 | 0.2% |
max_vl_folha_coligados_gp
Highly correlated
This variable is highly correlated with max_faturamento_est_coligados_gp and should be ignored for analysis
| Correlation | 0.9326 |
|---|
media_faturamento_est_coligados
Numeric
| Distinct count | 237 |
|---|---|
| Unique (%) | 41.9% |
| Missing (%) | 48.2% |
| Missing (n) | 273 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.6857e+07 |
|---|---|
| Minimum | 1.2364e+05 |
| Maximum | 1.1929e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.2364e+05 |
|---|---|
| 5-th percentile | 2.1e+05 |
| Q1 | 3.8319e+05 |
| Median | 1.9905e+06 |
| Q3 | 7.8792e+06 |
| 95-th percentile | 4.2989e+07 |
| Maximum | 1.1929e+09 |
| Range | 1.1928e+09 |
| Interquartile range | 7.496e+06 |
Descriptive statistics
| Standard deviation | 8.2355e+07 |
|---|---|
| Coef of variation | 4.8856 |
| Kurtosis | 148.75 |
| Mean | 1.6857e+07 |
| MAD | 2.3582e+07 |
| Skewness | 11.271 |
| Sum | 4.939e+09 |
| Variance | 6.7823e+15 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 2.1e+05 | 49 | 8.7% | |
| 9.3e+05 | 5 | 0.9% | |
| 1.2364e+05 | 2 | 0.4% | |
| 1.1127e+06 | 2 | 0.4% | |
| 1.6682e+05 | 2 | 0.4% | |
| 4.5e+05 | 2 | 0.4% | |
| 5.7e+05 | 2 | 0.4% | |
| 7.4183e+05 | 1 | 0.2% | |
| 3.1796e+06 | 1 | 0.2% | |
| 3.1584e+06 | 1 | 0.2% | |
| Other values (226) | 226 | 39.9% | |
| (Missing) | 273 | 48.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.2364e+05 | 2 | 0.4% | |
| 1.5455e+05 | 1 | 0.2% | |
| 1.6485e+05 | 1 | 0.2% | |
| 1.6682e+05 | 2 | 0.4% | |
| 1.8121e+05 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.1929e+09 | 1 | 0.2% | |
| 5.1855e+08 | 1 | 0.2% | |
| 3.482e+08 | 1 | 0.2% | |
| 3.04e+08 | 1 | 0.2% | |
| 2.1e+08 | 1 | 0.2% |
media_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with media_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.97553 |
|---|
media_filiais_coligados
Highly correlated
This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis
| Correlation | 0.93788 |
|---|
media_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with media_filiais_coligados and should be ignored for analysis
| Correlation | 0.97637 |
|---|
media_meses_servicos
Numeric
| Distinct count | 566 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 94.173 |
|---|---|
| Minimum | 5.5541 |
| Maximum | 459.97 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 5.5541 |
|---|---|
| 5-th percentile | 24.093 |
| Q1 | 43.726 |
| Median | 69.796 |
| Q3 | 146.37 |
| 95-th percentile | 211.79 |
| Maximum | 459.97 |
| Range | 454.41 |
| Interquartile range | 102.64 |
Descriptive statistics
| Standard deviation | 67.051 |
|---|---|
| Coef of variation | 0.71199 |
| Kurtosis | 2.2185 |
| Mean | 94.173 |
| MAD | 54.899 |
| Skewness | 1.281 |
| Sum | 53302 |
| Variance | 4495.8 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 44.588 | 1 | 0.2% | |
| 223.04 | 1 | 0.2% | |
| 64.525 | 1 | 0.2% | |
| 167.65 | 1 | 0.2% | |
| 12.775 | 1 | 0.2% | |
| 24.963 | 1 | 0.2% | |
| 47.901 | 1 | 0.2% | |
| 163.25 | 1 | 0.2% | |
| 70.287 | 1 | 0.2% | |
| 142.8 | 1 | 0.2% | |
| Other values (556) | 556 | 98.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 5.5541 | 1 | 0.2% | |
| 5.6098 | 1 | 0.2% | |
| 7.5586 | 1 | 0.2% | |
| 7.8968 | 1 | 0.2% | |
| 8.4043 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 459.97 | 1 | 0.2% | |
| 409.3 | 1 | 0.2% | |
| 353.95 | 1 | 0.2% | |
| 319.02 | 1 | 0.2% | |
| 313.49 | 1 | 0.2% |
media_meses_servicos_all
Numeric
| Distinct count | 566 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 80.261 |
|---|---|
| Minimum | 2.7073 |
| Maximum | 944.63 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2.7073 |
|---|---|
| 5-th percentile | 12.328 |
| Q1 | 24.679 |
| Median | 43.504 |
| Q3 | 113.48 |
| 95-th percentile | 241.55 |
| Maximum | 944.63 |
| Range | 941.93 |
| Interquartile range | 88.8 |
Descriptive statistics
| Standard deviation | 88.567 |
|---|---|
| Coef of variation | 1.1035 |
| Kurtosis | 18.79 |
| Mean | 80.261 |
| MAD | 62.934 |
| Skewness | 3.1463 |
| Sum | 45428 |
| Variance | 7844.1 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 41.333 | 1 | 0.2% | |
| 99.279 | 1 | 0.2% | |
| 51.131 | 1 | 0.2% | |
| 27.848 | 1 | 0.2% | |
| 29.978 | 1 | 0.2% | |
| 29.744 | 1 | 0.2% | |
| 55.641 | 1 | 0.2% | |
| 73.271 | 1 | 0.2% | |
| 30.596 | 1 | 0.2% | |
| 11.399 | 1 | 0.2% | |
| Other values (556) | 556 | 98.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2.7073 | 1 | 0.2% | |
| 6.9806 | 1 | 0.2% | |
| 6.9941 | 1 | 0.2% | |
| 7.1839 | 1 | 0.2% | |
| 8.1179 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 944.63 | 1 | 0.2% | |
| 533.92 | 1 | 0.2% | |
| 519.21 | 1 | 0.2% | |
| 452.33 | 1 | 0.2% | |
| 430.08 | 1 | 0.2% |
media_vl_folha_coligados
Numeric
| Distinct count | 213 |
|---|---|
| Unique (%) | 37.6% |
| Missing (%) | 58.7% |
| Missing (n) | 332 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.12e+06 |
|---|---|
| Minimum | 61819 |
| Maximum | 3.5404e+08 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 61819 |
|---|---|
| 5-th percentile | 1.1643e+05 |
| Q1 | 6.1819e+05 |
| Median | 2.1194e+06 |
| Q3 | 5.3963e+06 |
| 95-th percentile | 2.1135e+07 |
| Maximum | 3.5404e+08 |
| Range | 3.5398e+08 |
| Interquartile range | 4.7781e+06 |
Descriptive statistics
| Standard deviation | 2.6367e+07 |
|---|---|
| Coef of variation | 3.7032 |
| Kurtosis | 132.71 |
| Mean | 7.12e+06 |
| MAD | 8.2936e+06 |
| Skewness | 10.705 |
| Sum | 1.6661e+09 |
| Variance | 6.952e+14 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 61819 | 9 | 1.6% | |
| 6.1819e+05 | 3 | 0.5% | |
| 2.4728e+05 | 3 | 0.5% | |
| 1.4424e+05 | 3 | 0.5% | |
| 1.8546e+05 | 3 | 0.5% | |
| 5.5637e+05 | 2 | 0.4% | |
| 6.8001e+05 | 2 | 0.4% | |
| 1.6485e+05 | 2 | 0.4% | |
| 1.257e+06 | 2 | 0.4% | |
| 1.2364e+05 | 2 | 0.4% | |
| Other values (202) | 203 | 35.9% | |
| (Missing) | 332 | 58.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 61819 | 9 | 1.6% | |
| 82426 | 1 | 0.2% | |
| 92729 | 1 | 0.2% | |
| 1.0303e+05 | 1 | 0.2% | |
| 1.2364e+05 | 2 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.5404e+08 | 1 | 0.2% | |
| 1.2942e+08 | 1 | 0.2% | |
| 1.2343e+08 | 1 | 0.2% | |
| 4.8631e+07 | 1 | 0.2% | |
| 4.0188e+07 | 1 | 0.2% |
media_vl_folha_coligados_gp
Highly correlated
This variable is highly correlated with media_faturamento_est_coligados_gp and should be ignored for analysis
| Correlation | 0.93982 |
|---|
meses_ultima_contratacaco
Numeric
| Distinct count | 212 |
|---|---|
| Unique (%) | 37.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.003 |
|---|---|
| Minimum | 1.9333 |
| Maximum | 405.73 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.9333 |
|---|---|
| 5-th percentile | 2.0333 |
| Q1 | 2.4417 |
| Median | 3.9333 |
| Q3 | 23.95 |
| 95-th percentile | 34.367 |
| Maximum | 405.73 |
| Range | 403.8 |
| Interquartile range | 21.508 |
Descriptive statistics
| Standard deviation | 21.492 |
|---|---|
| Coef of variation | 1.6528 |
| Kurtosis | 197.63 |
| Mean | 13.003 |
| MAD | 12.468 |
| Skewness | 11.233 |
| Sum | 7359.7 |
| Variance | 461.9 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 2.9333 | 37 | 6.5% | |
| 2.3 | 32 | 5.7% | |
| 23.2 | 18 | 3.2% | |
| 2 | 16 | 2.8% | |
| 2.0667 | 16 | 2.8% | |
| 2.2667 | 16 | 2.8% | |
| 2.5333 | 13 | 2.3% | |
| 3.9333 | 12 | 2.1% | |
| 2.7667 | 12 | 2.1% | |
| 2.2 | 12 | 2.1% | |
| Other values (202) | 382 | 67.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.9333 | 1 | 0.2% | |
| 1.9667 | 4 | 0.7% | |
| 2 | 16 | 2.8% | |
| 2.0333 | 12 | 2.1% | |
| 2.0667 | 16 | 2.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 405.73 | 1 | 0.2% | |
| 106.37 | 1 | 0.2% | |
| 65.833 | 1 | 0.2% | |
| 63.167 | 1 | 0.2% | |
| 62.833 | 1 | 0.2% |
min_faturamento_est_coligados
Numeric
| Distinct count | 61 |
|---|---|
| Unique (%) | 10.8% |
| Missing (%) | 48.2% |
| Missing (n) | 273 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.1133e+06 |
|---|---|
| Minimum | 0 |
| Maximum | 6.0995e+07 |
| Zeros (%) | 0.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 79429 |
| Q1 | 2.1e+05 |
| Median | 2.1e+05 |
| Q3 | 2.1e+05 |
| 95-th percentile | 3.8843e+06 |
| Maximum | 6.0995e+07 |
| Range | 6.0995e+07 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 4.7212e+06 |
|---|---|
| Coef of variation | 4.2405 |
| Kurtosis | 99.342 |
| Mean | 1.1133e+06 |
| MAD | 1.5638e+06 |
| Skewness | 9.1002 |
| Sum | 3.2621e+08 |
| Variance | 2.229e+13 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 2.1e+05 | 173 | 30.6% | |
| 1.2364e+05 | 26 | 4.6% | |
| 1.8546e+05 | 7 | 1.2% | |
| 41213 | 6 | 1.1% | |
| 9.3e+05 | 6 | 1.1% | |
| 2.0606e+05 | 4 | 0.7% | |
| 1.5455e+05 | 3 | 0.5% | |
| 82426 | 3 | 0.5% | |
| 74933 | 2 | 0.4% | |
| 6.1819e+05 | 2 | 0.4% | |
| Other values (50) | 61 | 10.8% | |
| (Missing) | 273 | 48.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.2% | |
| 9141 | 1 | 0.2% | |
| 19079 | 1 | 0.2% | |
| 41213 | 6 | 1.1% | |
| 50000 | 2 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6.0995e+07 | 1 | 0.2% | |
| 3.3794e+07 | 1 | 0.2% | |
| 2.3182e+07 | 1 | 0.2% | |
| 2.1328e+07 | 1 | 0.2% | |
| 2.0091e+07 | 1 | 0.2% |
min_faturamento_est_coligados_gp
Highly correlated
This variable is highly correlated with min_faturamento_est_coligados and should be ignored for analysis
| Correlation | 0.94763 |
|---|
min_filiais_coligados
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | 1.8% |
| Missing (%) | 73.0% |
| Missing (n) | 413 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.719 |
|---|---|
| Minimum | 1 |
| Maximum | 33 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 33 |
| Range | 32 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 2.8573 |
|---|---|
| Coef of variation | 1.6622 |
| Kurtosis | 95.774 |
| Mean | 1.719 |
| MAD | 1.1184 |
| Skewness | 9.0067 |
| Sum | 263 |
| Variance | 8.1639 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 119 | 21.0% | |
| 2 | 17 | 3.0% | |
| 3 | 5 | 0.9% | |
| 5 | 3 | 0.5% | |
| 4 | 3 | 0.5% | |
| 8 | 2 | 0.4% | |
| 6 | 2 | 0.4% | |
| 7 | 1 | 0.2% | |
| 33 | 1 | 0.2% | |
| (Missing) | 413 | 73.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 119 | 21.0% | |
| 2 | 17 | 3.0% | |
| 3 | 5 | 0.9% | |
| 4 | 3 | 0.5% | |
| 5 | 3 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 33 | 1 | 0.2% | |
| 8 | 2 | 0.4% | |
| 7 | 1 | 0.2% | |
| 6 | 2 | 0.4% | |
| 5 | 3 | 0.5% |
min_funcionarios_coligados_gp
Numeric
| Distinct count | 59 |
|---|---|
| Unique (%) | 10.4% |
| Missing (%) | 55.5% |
| Missing (n) | 314 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 27.286 |
|---|---|
| Minimum | 0 |
| Maximum | 2112 |
| Zeros (%) | 16.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1.5 |
| Q3 | 10 |
| 95-th percentile | 100.25 |
| Maximum | 2112 |
| Range | 2112 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 143.46 |
|---|---|
| Coef of variation | 5.2578 |
| Kurtosis | 180.08 |
| Mean | 27.286 |
| MAD | 40.739 |
| Skewness | 12.67 |
| Sum | 6876 |
| Variance | 20582 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 93 | 16.4% | |
| 1 | 33 | 5.8% | |
| 2 | 16 | 2.8% | |
| 3 | 14 | 2.5% | |
| 4 | 8 | 1.4% | |
| 5 | 7 | 1.2% | |
| 7 | 6 | 1.1% | |
| 10 | 6 | 1.1% | |
| 9 | 5 | 0.9% | |
| 6 | 5 | 0.9% | |
| Other values (48) | 59 | 10.4% | |
| (Missing) | 314 | 55.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 93 | 16.4% | |
| 1 | 33 | 5.8% | |
| 2 | 16 | 2.8% | |
| 3 | 14 | 2.5% | |
| 4 | 8 | 1.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2112 | 1 | 0.2% | |
| 592 | 1 | 0.2% | |
| 360 | 1 | 0.2% | |
| 257 | 1 | 0.2% | |
| 235 | 1 | 0.2% |
min_meses_servicos
Highly correlated
This variable is highly correlated with meses_ultima_contratacaco and should be ignored for analysis
| Correlation | 0.98348 |
|---|
min_meses_servicos_all
Numeric
| Distinct count | 152 |
|---|---|
| Unique (%) | 26.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.84376 |
|---|---|
| Minimum | -12.033 |
| Maximum | 266.17 |
| Zeros (%) | 6.2% |
Quantile statistics
| Minimum | -12.033 |
|---|---|
| 5-th percentile | -6.1 |
| Q1 | -0.63333 |
| Median | -0.26667 |
| Q3 | 0.4 |
| 95-th percentile | 8.1333 |
| Maximum | 266.17 |
| Range | 278.2 |
| Interquartile range | 1.0333 |
Descriptive statistics
| Standard deviation | 12.152 |
|---|---|
| Coef of variation | 14.402 |
| Kurtosis | 403.93 |
| Mean | 0.84376 |
| MAD | 3.0247 |
| Skewness | 18.649 |
| Sum | 477.57 |
| Variance | 147.68 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 35 | 6.2% | |
| -0.033333 | 30 | 5.3% | |
| -0.63333 | 24 | 4.2% | |
| -0.5 | 23 | 4.1% | |
| -0.7 | 18 | 3.2% | |
| -0.36667 | 16 | 2.8% | |
| -0.43333 | 14 | 2.5% | |
| -0.56667 | 13 | 2.3% | |
| 1 | 13 | 2.3% | |
| -0.33333 | 12 | 2.1% | |
| Other values (142) | 368 | 65.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -12.033 | 1 | 0.2% | |
| -11.9 | 1 | 0.2% | |
| -11.667 | 1 | 0.2% | |
| -11.2 | 3 | 0.5% | |
| -11.167 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 266.17 | 1 | 0.2% | |
| 35.4 | 1 | 0.2% | |
| 34.333 | 1 | 0.2% | |
| 27.5 | 1 | 0.2% | |
| 27.267 | 1 | 0.2% |
min_vl_folha_coligados
Highly correlated
This variable is highly correlated with media_vl_folha_coligados and should be ignored for analysis
| Correlation | 0.92717 |
|---|
min_vl_folha_coligados_gp
Highly correlated
This variable is highly correlated with min_vl_folha_coligados and should be ignored for analysis
| Correlation | 0.95645 |
|---|
natureza_juridica_macro
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ENTIDADES EMPRESARIAIS | |
|---|---|
| OUTROS | |
| ADMINISTRACAO PUBLICA | 56 |
| Value | Count | Frequency (%) | |
| ENTIDADES EMPRESARIAIS | 323 | 57.1% | |
| OUTROS | 152 | 26.9% | |
| ADMINISTRACAO PUBLICA | 56 | 9.9% | |
| ENTIDADES SEM FINS LUCRATIVOS | 35 | 6.2% |
| Max length | 29 |
|---|---|
| Mean length | 18.037 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_divisao
Categorical
| Distinct count | 60 |
|---|---|
| Unique (%) | 10.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| COMERCIO VAREJISTA | 46 |
| COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS | 40 |
| Other values (57) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 163 | 28.8% | |
| COMERCIO VAREJISTA | 46 | 8.1% | |
| COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS | 40 | 7.1% | |
| EDUCACAO | 33 | 5.8% | |
| CONSTRUCAO DE EDIFICIOS | 31 | 5.5% | |
| ATIVIDADES DE ATENCAO A SAUDE HUMANA | 22 | 3.9% | |
| SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS | 22 | 3.9% | |
| COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 21 | 3.7% | |
| TRANSPORTE TERRESTRE | 20 | 3.5% | |
| ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS | 11 | 1.9% | |
| Other values (50) | 157 | 27.7% |
| Max length | 120 |
|---|---|
| Mean length | 41.193 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_meso_regiao
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | 3.4% |
| Missing (%) | 12.4% |
| Missing (n) | 70 |
| CENTRO AMAZONENSE | |
|---|---|
| NORTE MARANHENSE | |
| CENTRO NORTE PIAUIENSE | |
| Other values (15) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| CENTRO AMAZONENSE | 138 | 24.4% | |
| NORTE MARANHENSE | 66 | 11.7% | |
| CENTRO NORTE PIAUIENSE | 62 | 11.0% | |
| LESTE POTIGUAR | 52 | 9.2% | |
| VALE DO ACRE | 32 | 5.7% | |
| OESTE POTIGUAR | 28 | 4.9% | |
| OESTE MARANHENSE | 16 | 2.8% | |
| SUDESTE PIAUIENSE | 15 | 2.7% | |
| CENTRO MARANHENSE | 14 | 2.5% | |
| SUDOESTE PIAUIENSE | 14 | 2.5% | |
| Other values (8) | 59 | 10.4% | |
| (Missing) | 70 | 12.4% |
| Max length | 22 |
|---|---|
| Mean length | 14.823 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_micro_regiao
Categorical
| Distinct count | 61 |
|---|---|
| Unique (%) | 10.8% |
| Missing (%) | 12.4% |
| Missing (n) | 70 |
| MANAUS | |
|---|---|
| AGLOMERACAO URBANA DE SAO LUIS | |
| NATAL | 48 |
| Other values (57) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| MANAUS | 126 | 22.3% | |
| AGLOMERACAO URBANA DE SAO LUIS | 58 | 10.2% | |
| NATAL | 48 | 8.5% | |
| TERESINA | 46 | 8.1% | |
| RIO BRANCO | 29 | 5.1% | |
| MOSSORO | 16 | 2.8% | |
| IMPERATRIZ | 12 | 2.1% | |
| MEDIO MEARIM | 8 | 1.4% | |
| ALTO MEDIO CANINDE | 8 | 1.4% | |
| PICOS | 7 | 1.2% | |
| Other values (50) | 138 | 24.4% | |
| (Missing) | 70 | 12.4% |
| Max length | 33 |
|---|---|
| Mean length | 10.749 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nm_segmento
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | 3.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | |
|---|---|
| COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | |
| INDUSTRIAS DE TRANSFORMACAO | |
| Other values (16) |
| Value | Count | Frequency (%) | |
| ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 163 | 28.8% | |
| COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 107 | 18.9% | |
| INDUSTRIAS DE TRANSFORMACAO | 64 | 11.3% | |
| CONSTRUCAO | 46 | 8.1% | |
| ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 42 | 7.4% | |
| EDUCACAO | 33 | 5.8% | |
| TRANSPORTE ARMAZENAGEM E CORREIO | 25 | 4.4% | |
| SAUDE HUMANA E SERVICOS SOCIAIS | 25 | 4.4% | |
| OUTRAS ATIVIDADES DE SERVICOS | 12 | 2.1% | |
| ALOJAMENTO E ALIMENTACAO | 11 | 1.9% | |
| Other values (9) | 38 | 6.7% |
| Max length | 62 |
|---|---|
| Mean length | 39.799 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
nu_meses_rescencia
Numeric
| Distinct count | 11 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.753 |
|---|---|
| Minimum | 21 |
| Maximum | 49 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 21 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 23 |
| Median | 23 |
| Q3 | 23 |
| 95-th percentile | 48 |
| Maximum | 49 |
| Range | 28 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 5.923 |
|---|---|
| Coef of variation | 0.23929 |
| Kurtosis | 11.23 |
| Mean | 24.753 |
| MAD | 2.9508 |
| Skewness | 3.5895 |
| Sum | 14010 |
| Variance | 35.082 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 23 | 410 | 72.4% | |
| 24 | 64 | 11.3% | |
| 48 | 29 | 5.1% | |
| 26 | 24 | 4.2% | |
| 22 | 18 | 3.2% | |
| 27 | 6 | 1.1% | |
| 21 | 5 | 0.9% | |
| 47 | 4 | 0.7% | |
| 25 | 4 | 0.7% | |
| 28 | 1 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 21 | 5 | 0.9% | |
| 22 | 18 | 3.2% | |
| 23 | 410 | 72.4% | |
| 24 | 64 | 11.3% | |
| 25 | 4 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 49 | 1 | 0.2% | |
| 48 | 29 | 5.1% | |
| 47 | 4 | 0.7% | |
| 28 | 1 | 0.2% | |
| 27 | 6 | 1.1% |
percent_func_genero_fem
Numeric
| Distinct count | 535 |
|---|---|
| Unique (%) | 94.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 40.565 |
|---|---|
| Minimum | 0 |
| Maximum | 87.5 |
| Zeros (%) | 0.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.955 |
| Q1 | 17.94 |
| Median | 42.86 |
| Q3 | 61.883 |
| 95-th percentile | 76.468 |
| Maximum | 87.5 |
| Range | 87.5 |
| Interquartile range | 43.943 |
Descriptive statistics
| Standard deviation | 24.417 |
|---|---|
| Coef of variation | 0.60193 |
| Kurtosis | -1.2919 |
| Mean | 40.565 |
| MAD | 21.669 |
| Skewness | -0.036441 |
| Sum | 22960 |
| Variance | 596.2 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 50 | 5 | 0.9% | |
| 51.58 | 3 | 0.5% | |
| 72.93 | 3 | 0.5% | |
| 30.26 | 2 | 0.4% | |
| 52.01 | 2 | 0.4% | |
| 51.97 | 2 | 0.4% | |
| 3.95 | 2 | 0.4% | |
| 42.86 | 2 | 0.4% | |
| 69.14 | 2 | 0.4% | |
| 64.88 | 2 | 0.4% | |
| Other values (525) | 541 | 95.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.2% | |
| 0.5 | 1 | 0.2% | |
| 0.56 | 1 | 0.2% | |
| 0.68 | 2 | 0.4% | |
| 0.89 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 87.5 | 1 | 0.2% | |
| 87.19 | 1 | 0.2% | |
| 86.9 | 1 | 0.2% | |
| 86.26 | 1 | 0.2% | |
| 86.06 | 1 | 0.2% |
percent_func_genero_masc
Numeric
| Distinct count | 535 |
|---|---|
| Unique (%) | 94.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 59.435 |
|---|---|
| Minimum | 12.5 |
| Maximum | 100 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 12.5 |
|---|---|
| 5-th percentile | 23.532 |
| Q1 | 38.117 |
| Median | 57.14 |
| Q3 | 82.06 |
| 95-th percentile | 96.045 |
| Maximum | 100 |
| Range | 87.5 |
| Interquartile range | 43.943 |
Descriptive statistics
| Standard deviation | 24.417 |
|---|---|
| Coef of variation | 0.41082 |
| Kurtosis | -1.2919 |
| Mean | 59.435 |
| MAD | 21.668 |
| Skewness | 0.03644 |
| Sum | 33640 |
| Variance | 596.2 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 50 | 5 | 0.9% | |
| 48.42 | 3 | 0.5% | |
| 27.07 | 3 | 0.5% | |
| 95.65 | 2 | 0.4% | |
| 30.86 | 2 | 0.4% | |
| 35.71 | 2 | 0.4% | |
| 48.03 | 2 | 0.4% | |
| 35.11 | 2 | 0.4% | |
| 60.29 | 2 | 0.4% | |
| 41.15 | 2 | 0.4% | |
| Other values (525) | 541 | 95.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 12.5 | 1 | 0.2% | |
| 12.81 | 1 | 0.2% | |
| 13.1 | 1 | 0.2% | |
| 13.74 | 1 | 0.2% | |
| 13.94 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 1 | 0.2% | |
| 99.5 | 1 | 0.2% | |
| 99.44 | 1 | 0.2% | |
| 99.32 | 2 | 0.4% | |
| 99.11 | 1 | 0.2% |
qt_admitidos
Numeric
| Distinct count | 444 |
|---|---|
| Unique (%) | 78.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 961.98 |
|---|---|
| Minimum | 24 |
| Maximum | 21259 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 24 |
|---|---|
| 5-th percentile | 133.5 |
| Q1 | 257.75 |
| Median | 435 |
| Q3 | 904.5 |
| 95-th percentile | 3936.8 |
| Maximum | 21259 |
| Range | 21235 |
| Interquartile range | 646.75 |
Descriptive statistics
| Standard deviation | 1740.2 |
|---|---|
| Coef of variation | 1.809 |
| Kurtosis | 42.738 |
| Mean | 961.98 |
| MAD | 873.61 |
| Skewness | 5.4655 |
| Sum | 5.4448e+05 |
| Variance | 3.0283e+06 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 246 | 5 | 0.9% | |
| 419 | 4 | 0.7% | |
| 210 | 4 | 0.7% | |
| 275 | 4 | 0.7% | |
| 309 | 3 | 0.5% | |
| 311 | 3 | 0.5% | |
| 156 | 3 | 0.5% | |
| 293 | 3 | 0.5% | |
| 501 | 3 | 0.5% | |
| 270 | 3 | 0.5% | |
| Other values (434) | 531 | 93.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 24 | 1 | 0.2% | |
| 33 | 1 | 0.2% | |
| 53 | 1 | 0.2% | |
| 66 | 1 | 0.2% | |
| 76 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 21259 | 1 | 0.2% | |
| 11739 | 1 | 0.2% | |
| 11544 | 1 | 0.2% | |
| 11466 | 1 | 0.2% | |
| 8340 | 1 | 0.2% |
qt_admitidos_12meses
Numeric
| Distinct count | 125 |
|---|---|
| Unique (%) | 22.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 37.571 |
|---|---|
| Minimum | 0 |
| Maximum | 1256 |
| Zeros (%) | 35.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 9 |
| Q3 | 35 |
| 95-th percentile | 158.75 |
| Maximum | 1256 |
| Range | 1256 |
| Interquartile range | 35 |
Descriptive statistics
| Standard deviation | 93.702 |
|---|---|
| Coef of variation | 2.494 |
| Kurtosis | 61.172 |
| Mean | 37.571 |
| MAD | 45.28 |
| Skewness | 6.5011 |
| Sum | 21265 |
| Variance | 8780 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 199 | 35.2% | |
| 10 | 12 | 2.1% | |
| 6 | 12 | 2.1% | |
| 14 | 11 | 1.9% | |
| 1 | 11 | 1.9% | |
| 16 | 11 | 1.9% | |
| 4 | 11 | 1.9% | |
| 5 | 10 | 1.8% | |
| 2 | 10 | 1.8% | |
| 7 | 9 | 1.6% | |
| Other values (115) | 270 | 47.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 199 | 35.2% | |
| 1 | 11 | 1.9% | |
| 2 | 10 | 1.8% | |
| 3 | 9 | 1.6% | |
| 4 | 11 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1256 | 1 | 0.2% | |
| 642 | 1 | 0.2% | |
| 574 | 1 | 0.2% | |
| 554 | 2 | 0.4% | |
| 475 | 1 | 0.2% |
qt_alteracao_socio_180d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_365d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_90d
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_alteracao_socio_total
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_art
Numeric
| Distinct count | 48 |
|---|---|
| Unique (%) | 8.5% |
| Missing (%) | 53.7% |
| Missing (n) | 304 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 11.16 |
|---|---|
| Minimum | 1 |
| Maximum | 426 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 3 |
| Q3 | 9 |
| 95-th percentile | 43 |
| Maximum | 426 |
| Range | 425 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 31.223 |
|---|---|
| Coef of variation | 2.7977 |
| Kurtosis | 121.19 |
| Mean | 11.16 |
| MAD | 12.57 |
| Skewness | 9.7215 |
| Sum | 2924 |
| Variance | 974.88 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 68 | 12.0% | |
| 2 | 42 | 7.4% | |
| 3 | 30 | 5.3% | |
| 4 | 18 | 3.2% | |
| 6 | 13 | 2.3% | |
| 5 | 12 | 2.1% | |
| 14 | 6 | 1.1% | |
| 8 | 6 | 1.1% | |
| 11 | 6 | 1.1% | |
| 10 | 6 | 1.1% | |
| Other values (37) | 55 | 9.7% | |
| (Missing) | 304 | 53.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 68 | 12.0% | |
| 2 | 42 | 7.4% | |
| 3 | 30 | 5.3% | |
| 4 | 18 | 3.2% | |
| 5 | 12 | 2.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 426 | 1 | 0.2% | |
| 126 | 1 | 0.2% | |
| 118 | 1 | 0.2% | |
| 103 | 1 | 0.2% | |
| 98 | 1 | 0.2% |
qt_coligadas
Numeric
| Distinct count | 32 |
|---|---|
| Unique (%) | 5.7% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.1304 |
|---|---|
| Minimum | 1 |
| Maximum | 296 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 7 |
| 95-th percentile | 21.3 |
| Maximum | 296 |
| Range | 295 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 18.999 |
|---|---|
| Coef of variation | 2.6644 |
| Kurtosis | 180.91 |
| Mean | 7.1304 |
| MAD | 6.6506 |
| Skewness | 12.238 |
| Sum | 2132 |
| Variance | 360.95 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 71 | 12.5% | |
| 2 | 46 | 8.1% | |
| 3 | 40 | 7.1% | |
| 4 | 32 | 5.7% | |
| 5 | 19 | 3.4% | |
| 6 | 14 | 2.5% | |
| 9 | 11 | 1.9% | |
| 7 | 10 | 1.8% | |
| 8 | 8 | 1.4% | |
| 10 | 8 | 1.4% | |
| Other values (21) | 40 | 7.1% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 71 | 12.5% | |
| 2 | 46 | 8.1% | |
| 3 | 40 | 7.1% | |
| 4 | 32 | 5.7% | |
| 5 | 19 | 3.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 296 | 1 | 0.2% | |
| 68 | 1 | 0.2% | |
| 57 | 1 | 0.2% | |
| 53 | 2 | 0.4% | |
| 48 | 1 | 0.2% |
qt_coligados
Highly correlated
This variable is highly correlated with qt_coligadas and should be ignored for analysis
| Correlation | 1 |
|---|
qt_coligados_agropecuaria
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | 1.2% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.22408 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | 46.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.90113 |
|---|---|
| Coef of variation | 4.0215 |
| Kurtosis | 61.004 |
| Mean | 0.22408 |
| MAD | 0.3972 |
| Skewness | 7.0219 |
| Sum | 67 |
| Variance | 0.81204 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 265 | 46.8% | |
| 1 | 20 | 3.5% | |
| 2 | 8 | 1.4% | |
| 3 | 3 | 0.5% | |
| 9 | 2 | 0.4% | |
| 4 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 265 | 46.8% | |
| 1 | 20 | 3.5% | |
| 2 | 8 | 1.4% | |
| 3 | 3 | 0.5% | |
| 4 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 2 | 0.4% | |
| 4 | 1 | 0.2% | |
| 3 | 3 | 0.5% | |
| 2 | 8 | 1.4% | |
| 1 | 20 | 3.5% |
qt_coligados_atividade_alto
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_atividade_baixo
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_atividade_inativo
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_atividade_medio
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_atividade_mt_baixo
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_ativo
Highly correlated
This variable is highly correlated with qt_coligados and should be ignored for analysis
| Correlation | 0.99984 |
|---|
qt_coligados_baixada
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| 0 | |
|---|---|
| 1 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 298 | 52.7% | |
| 1 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
qt_coligados_ccivil
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | 2.1% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.4381 |
|---|---|
| Minimum | 0 |
| Maximum | 270 |
| Zeros (%) | 38.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 270 |
| Range | 270 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 15.654 |
|---|---|
| Coef of variation | 10.885 |
| Kurtosis | 293.63 |
| Mean | 1.4381 |
| MAD | 2.257 |
| Skewness | 17.064 |
| Sum | 430 |
| Variance | 245.03 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 220 | 38.9% | |
| 1 | 48 | 8.5% | |
| 2 | 15 | 2.7% | |
| 3 | 8 | 1.4% | |
| 4 | 2 | 0.4% | |
| 270 | 1 | 0.2% | |
| 7 | 1 | 0.2% | |
| 8 | 1 | 0.2% | |
| 12 | 1 | 0.2% | |
| 13 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 220 | 38.9% | |
| 1 | 48 | 8.5% | |
| 2 | 15 | 2.7% | |
| 3 | 8 | 1.4% | |
| 4 | 2 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 270 | 1 | 0.2% | |
| 13 | 1 | 0.2% | |
| 12 | 1 | 0.2% | |
| 10 | 1 | 0.2% | |
| 8 | 1 | 0.2% |
qt_coligados_centro
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | 1.6% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.20401 |
|---|---|
| Minimum | 0 |
| Maximum | 13 |
| Zeros (%) | 48.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.05 |
|---|---|
| Coef of variation | 5.1468 |
| Kurtosis | 89.794 |
| Mean | 0.20401 |
| MAD | 0.37118 |
| Skewness | 8.7235 |
| Sum | 61 |
| Variance | 1.1025 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 272 | 48.1% | |
| 1 | 18 | 3.2% | |
| 2 | 4 | 0.7% | |
| 8 | 1 | 0.2% | |
| 3 | 1 | 0.2% | |
| 4 | 1 | 0.2% | |
| 13 | 1 | 0.2% | |
| 7 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 272 | 48.1% | |
| 1 | 18 | 3.2% | |
| 2 | 4 | 0.7% | |
| 3 | 1 | 0.2% | |
| 4 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13 | 1 | 0.2% | |
| 8 | 1 | 0.2% | |
| 7 | 1 | 0.2% | |
| 4 | 1 | 0.2% | |
| 3 | 1 | 0.2% |
qt_coligados_comercio
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | 2.7% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.408 |
|---|---|
| Minimum | 0 |
| Maximum | 25 |
| Zeros (%) | 26.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 2 |
| 95-th percentile | 6 |
| Maximum | 25 |
| Range | 25 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 2.7831 |
|---|---|
| Coef of variation | 1.9766 |
| Kurtosis | 27.489 |
| Mean | 1.408 |
| MAD | 1.609 |
| Skewness | 4.5106 |
| Sum | 421 |
| Variance | 7.7457 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 152 | 26.9% | |
| 1 | 65 | 11.5% | |
| 2 | 28 | 4.9% | |
| 3 | 24 | 4.2% | |
| 4 | 10 | 1.8% | |
| 6 | 5 | 0.9% | |
| 8 | 4 | 0.7% | |
| 5 | 4 | 0.7% | |
| 14 | 2 | 0.4% | |
| 15 | 1 | 0.2% | |
| Other values (4) | 4 | 0.7% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 152 | 26.9% | |
| 1 | 65 | 11.5% | |
| 2 | 28 | 4.9% | |
| 3 | 24 | 4.2% | |
| 4 | 10 | 1.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 25 | 1 | 0.2% | |
| 20 | 1 | 0.2% | |
| 15 | 1 | 0.2% | |
| 14 | 2 | 0.4% | |
| 11 | 1 | 0.2% |
qt_coligados_epp
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_exterior
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| 0 | |
|---|---|
| 1 | 5 |
| 2 | 3 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 291 | 51.4% | |
| 1 | 5 | 0.9% | |
| 2 | 3 | 0.5% | |
| (Missing) | 267 | 47.2% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
qt_coligados_inapta
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| 0 | |
|---|---|
| 1 | 8 |
| 2 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 290 | 51.2% | |
| 1 | 8 | 1.4% | |
| 2 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
qt_coligados_industria
Numeric
| Distinct count | 11 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.82274 |
|---|---|
| Minimum | 0 |
| Maximum | 48 |
| Zeros (%) | 37.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 48 |
| Range | 48 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 3.4367 |
|---|---|
| Coef of variation | 4.1771 |
| Kurtosis | 127.19 |
| Mean | 0.82274 |
| MAD | 1.1612 |
| Skewness | 10.29 |
| Sum | 246 |
| Variance | 11.811 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 211 | 37.3% | |
| 1 | 54 | 9.5% | |
| 2 | 15 | 2.7% | |
| 3 | 9 | 1.6% | |
| 4 | 3 | 0.5% | |
| 6 | 2 | 0.4% | |
| 21 | 2 | 0.4% | |
| 10 | 1 | 0.2% | |
| 48 | 1 | 0.2% | |
| 11 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 211 | 37.3% | |
| 1 | 54 | 9.5% | |
| 2 | 15 | 2.7% | |
| 3 | 9 | 1.6% | |
| 4 | 3 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 48 | 1 | 0.2% | |
| 21 | 2 | 0.4% | |
| 11 | 1 | 0.2% | |
| 10 | 1 | 0.2% | |
| 6 | 2 | 0.4% |
qt_coligados_ltda
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.086957 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 50.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.61234 |
|---|---|
| Coef of variation | 7.0419 |
| Kurtosis | 122.72 |
| Mean | 0.086957 |
| MAD | 0.16635 |
| Skewness | 10.544 |
| Sum | 26 |
| Variance | 0.37496 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 286 | 50.5% | |
| 1 | 10 | 1.8% | |
| 2 | 1 | 0.2% | |
| 8 | 1 | 0.2% | |
| 6 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 286 | 50.5% | |
| 1 | 10 | 1.8% | |
| 2 | 1 | 0.2% | |
| 6 | 1 | 0.2% | |
| 8 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | 0.2% | |
| 6 | 1 | 0.2% | |
| 2 | 1 | 0.2% | |
| 1 | 10 | 1.8% | |
| 0 | 286 | 50.5% |
qt_coligados_matriz
Highly correlated
This variable is highly correlated with qt_coligados_ativo and should be ignored for analysis
| Correlation | 0.99904 |
|---|
qt_coligados_me
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_mei
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| 0 | |
|---|---|
| 1 | 2 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 297 | 52.5% | |
| 1 | 2 | 0.4% | |
| (Missing) | 267 | 47.2% |
qt_coligados_nordeste
Numeric
| Distinct count | 23 |
|---|---|
| Unique (%) | 4.1% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.8328 |
|---|---|
| Minimum | 0 |
| Maximum | 41 |
| Zeros (%) | 24.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 4 |
| 95-th percentile | 13 |
| Maximum | 41 |
| Range | 41 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 5.3732 |
|---|---|
| Coef of variation | 1.8968 |
| Kurtosis | 19.608 |
| Mean | 2.8328 |
| MAD | 3.2835 |
| Skewness | 3.8214 |
| Sum | 847 |
| Variance | 28.871 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 141 | 24.9% | |
| 1 | 39 | 6.9% | |
| 2 | 24 | 4.2% | |
| 4 | 21 | 3.7% | |
| 3 | 19 | 3.4% | |
| 6 | 10 | 1.8% | |
| 5 | 8 | 1.4% | |
| 9 | 8 | 1.4% | |
| 10 | 5 | 0.9% | |
| 7 | 3 | 0.5% | |
| Other values (12) | 21 | 3.7% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 141 | 24.9% | |
| 1 | 39 | 6.9% | |
| 2 | 24 | 4.2% | |
| 3 | 19 | 3.4% | |
| 4 | 21 | 3.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 41 | 2 | 0.4% | |
| 28 | 1 | 0.2% | |
| 25 | 2 | 0.4% | |
| 21 | 1 | 0.2% | |
| 17 | 2 | 0.4% |
qt_coligados_norte
Numeric
| Distinct count | 20 |
|---|---|
| Unique (%) | 3.5% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.9398 |
|---|---|
| Minimum | 0 |
| Maximum | 52 |
| Zeros (%) | 28.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 2 |
| 95-th percentile | 9 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 4.657 |
|---|---|
| Coef of variation | 2.4008 |
| Kurtosis | 51.956 |
| Mean | 1.9398 |
| MAD | 2.4025 |
| Skewness | 6.0715 |
| Sum | 580 |
| Variance | 21.688 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 159 | 28.1% | |
| 1 | 54 | 9.5% | |
| 2 | 22 | 3.9% | |
| 3 | 18 | 3.2% | |
| 4 | 11 | 1.9% | |
| 5 | 8 | 1.4% | |
| 6 | 4 | 0.7% | |
| 7 | 4 | 0.7% | |
| 9 | 4 | 0.7% | |
| 14 | 3 | 0.5% | |
| Other values (9) | 12 | 2.1% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 159 | 28.1% | |
| 1 | 54 | 9.5% | |
| 2 | 22 | 3.9% | |
| 3 | 18 | 3.2% | |
| 4 | 11 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 52 | 1 | 0.2% | |
| 32 | 1 | 0.2% | |
| 23 | 1 | 0.2% | |
| 19 | 1 | 0.2% | |
| 17 | 1 | 0.2% |
qt_coligados_nula
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_coligados_sa
Highly correlated
This variable is highly correlated with qt_coligados_industria and should be ignored for analysis
| Correlation | 0.92957 |
|---|
qt_coligados_serviço
Numeric
| Distinct count | 26 |
|---|---|
| Unique (%) | 4.6% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.2441 |
|---|---|
| Minimum | 0 |
| Maximum | 51 |
| Zeros (%) | 10.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 3 |
| 95-th percentile | 12 |
| Maximum | 51 |
| Range | 51 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 5.6245 |
|---|---|
| Coef of variation | 1.7337 |
| Kurtosis | 25.503 |
| Mean | 3.2441 |
| MAD | 3.16 |
| Skewness | 4.371 |
| Sum | 970 |
| Variance | 31.635 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 93 | 16.4% | |
| 0 | 61 | 10.8% | |
| 2 | 48 | 8.5% | |
| 3 | 25 | 4.4% | |
| 4 | 19 | 3.4% | |
| 7 | 14 | 2.5% | |
| 12 | 6 | 1.1% | |
| 6 | 6 | 1.1% | |
| 5 | 6 | 1.1% | |
| 8 | 4 | 0.7% | |
| Other values (15) | 17 | 3.0% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 61 | 10.8% | |
| 1 | 93 | 16.4% | |
| 2 | 48 | 8.5% | |
| 3 | 25 | 4.4% | |
| 4 | 19 | 3.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51 | 1 | 0.2% | |
| 37 | 1 | 0.2% | |
| 31 | 1 | 0.2% | |
| 30 | 1 | 0.2% | |
| 25 | 1 | 0.2% |
qt_coligados_sudeste
Highly correlated
This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis
| Correlation | 0.92867 |
|---|
qt_coligados_sul
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.11037 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros (%) | 50.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.0056 |
|---|---|
| Coef of variation | 9.1115 |
| Kurtosis | 214.49 |
| Mean | 0.11037 |
| MAD | 0.21188 |
| Skewness | 14.048 |
| Sum | 33 |
| Variance | 1.0113 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 287 | 50.7% | |
| 1 | 9 | 1.6% | |
| 2 | 1 | 0.2% | |
| 6 | 1 | 0.2% | |
| 16 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 287 | 50.7% | |
| 1 | 9 | 1.6% | |
| 2 | 1 | 0.2% | |
| 6 | 1 | 0.2% | |
| 16 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 1 | 0.2% | |
| 6 | 1 | 0.2% | |
| 2 | 1 | 0.2% | |
| 1 | 9 | 1.6% | |
| 0 | 287 | 50.7% |
qt_coligados_suspensa
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_desligados
Numeric
| Distinct count | 414 |
|---|---|
| Unique (%) | 73.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 591.69 |
|---|---|
| Minimum | 7 |
| Maximum | 11079 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 28.5 |
| Q1 | 120 |
| Median | 238 |
| Q3 | 544.25 |
| 95-th percentile | 2180 |
| Maximum | 11079 |
| Range | 11072 |
| Interquartile range | 424.25 |
Descriptive statistics
| Standard deviation | 1141.4 |
|---|---|
| Coef of variation | 1.9291 |
| Kurtosis | 30.347 |
| Mean | 591.69 |
| MAD | 585.06 |
| Skewness | 4.9176 |
| Sum | 3.349e+05 |
| Variance | 1.3028e+06 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 199 | 5 | 0.9% | |
| 124 | 5 | 0.9% | |
| 214 | 4 | 0.7% | |
| 378 | 4 | 0.7% | |
| 221 | 4 | 0.7% | |
| 153 | 4 | 0.7% | |
| 9 | 3 | 0.5% | |
| 89 | 3 | 0.5% | |
| 52 | 3 | 0.5% | |
| 106 | 3 | 0.5% | |
| Other values (404) | 528 | 93.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 7 | 1 | 0.2% | |
| 8 | 3 | 0.5% | |
| 9 | 3 | 0.5% | |
| 10 | 1 | 0.2% | |
| 11 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 11079 | 1 | 0.2% | |
| 9979 | 1 | 0.2% | |
| 7843 | 1 | 0.2% | |
| 7233 | 1 | 0.2% | |
| 6802 | 1 | 0.2% |
qt_desligados_12meses
Numeric
| Distinct count | 111 |
|---|---|
| Unique (%) | 19.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 31.654 |
|---|---|
| Minimum | 0 |
| Maximum | 1041 |
| Zeros (%) | 33.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 9 |
| Q3 | 29 |
| 95-th percentile | 119.5 |
| Maximum | 1041 |
| Range | 1041 |
| Interquartile range | 29 |
Descriptive statistics
| Standard deviation | 78.75 |
|---|---|
| Coef of variation | 2.4879 |
| Kurtosis | 58.536 |
| Mean | 31.654 |
| MAD | 37.434 |
| Skewness | 6.3919 |
| Sum | 17916 |
| Variance | 6201.6 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 187 | 33.0% | |
| 10 | 16 | 2.8% | |
| 7 | 15 | 2.7% | |
| 1 | 13 | 2.3% | |
| 4 | 11 | 1.9% | |
| 5 | 11 | 1.9% | |
| 6 | 11 | 1.9% | |
| 15 | 11 | 1.9% | |
| 12 | 11 | 1.9% | |
| 18 | 11 | 1.9% | |
| Other values (101) | 269 | 47.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 187 | 33.0% | |
| 1 | 13 | 2.3% | |
| 2 | 10 | 1.8% | |
| 3 | 9 | 1.6% | |
| 4 | 11 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1041 | 1 | 0.2% | |
| 557 | 1 | 0.2% | |
| 480 | 1 | 0.2% | |
| 460 | 1 | 0.2% | |
| 443 | 1 | 0.2% |
qt_ex_funcionarios
Highly correlated
This variable is highly correlated with qt_desligados and should be ignored for analysis
| Correlation | 1 |
|---|
qt_filiais
Numeric
| Distinct count | 35 |
|---|---|
| Unique (%) | 6.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.4346 |
|---|---|
| Minimum | 0 |
| Maximum | 172 |
| Zeros (%) | 47.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 13 |
| Maximum | 172 |
| Range | 172 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 11.804 |
|---|---|
| Coef of variation | 3.4367 |
| Kurtosis | 106.49 |
| Mean | 3.4346 |
| MAD | 4.4989 |
| Skewness | 9.2098 |
| Sum | 1944 |
| Variance | 139.33 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 270 | 47.7% | |
| 1 | 108 | 19.1% | |
| 2 | 49 | 8.7% | |
| 3 | 29 | 5.1% | |
| 4 | 18 | 3.2% | |
| 6 | 18 | 3.2% | |
| 5 | 10 | 1.8% | |
| 7 | 9 | 1.6% | |
| 10 | 8 | 1.4% | |
| 8 | 6 | 1.1% | |
| Other values (25) | 41 | 7.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 270 | 47.7% | |
| 1 | 108 | 19.1% | |
| 2 | 49 | 8.7% | |
| 3 | 29 | 5.1% | |
| 4 | 18 | 3.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 172 | 1 | 0.2% | |
| 121 | 1 | 0.2% | |
| 116 | 1 | 0.2% | |
| 61 | 1 | 0.2% | |
| 51 | 1 | 0.2% |
qt_funcionarios
Highly correlated
This variable is highly correlated with idade_de_54_a_58 and should be ignored for analysis
| Correlation | 0.94732 |
|---|
qt_funcionarios_12meses
Highly correlated
This variable is highly correlated with qt_funcionarios and should be ignored for analysis
| Correlation | 0.99761 |
|---|
qt_funcionarios_24meses
Highly correlated
This variable is highly correlated with qt_funcionarios_12meses and should be ignored for analysis
| Correlation | 0.98334 |
|---|
qt_funcionarios_coligados
Numeric
| Distinct count | 163 |
|---|---|
| Unique (%) | 28.8% |
| Missing (%) | 55.5% |
| Missing (n) | 314 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 359.66 |
|---|---|
| Minimum | 0 |
| Maximum | 7222 |
| Zeros (%) | 3.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10.75 |
| Median | 80.5 |
| Q3 | 229.25 |
| 95-th percentile | 1727.7 |
| Maximum | 7222 |
| Range | 7222 |
| Interquartile range | 218.5 |
Descriptive statistics
| Standard deviation | 897.39 |
|---|---|
| Coef of variation | 2.4951 |
| Kurtosis | 21.645 |
| Mean | 359.66 |
| MAD | 460.51 |
| Skewness | 4.3418 |
| Sum | 90635 |
| Variance | 8.053e+05 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 18 | 3.2% | |
| 1 | 9 | 1.6% | |
| 3 | 7 | 1.2% | |
| 2 | 5 | 0.9% | |
| 4 | 4 | 0.7% | |
| 9 | 4 | 0.7% | |
| 7 | 4 | 0.7% | |
| 6 | 4 | 0.7% | |
| 12 | 3 | 0.5% | |
| 20 | 3 | 0.5% | |
| Other values (152) | 191 | 33.7% | |
| (Missing) | 314 | 55.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 18 | 3.2% | |
| 1 | 9 | 1.6% | |
| 2 | 5 | 0.9% | |
| 3 | 7 | 1.2% | |
| 4 | 4 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7222 | 1 | 0.2% | |
| 4770 | 1 | 0.2% | |
| 4487 | 1 | 0.2% | |
| 4311 | 1 | 0.2% | |
| 4124 | 1 | 0.2% |
qt_funcionarios_coligados_gp
Highly correlated
This variable is highly correlated with media_filiais_coligados and should be ignored for analysis
| Correlation | 0.90605 |
|---|
qt_funcionarios_grupo
Numeric
| Distinct count | 351 |
|---|---|
| Unique (%) | 62.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 580.98 |
|---|---|
| Minimum | 17 |
| Maximum | 95202 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 17 |
|---|---|
| 5-th percentile | 60.25 |
| Q1 | 99 |
| Median | 178 |
| Q3 | 375.25 |
| 95-th percentile | 1285.2 |
| Maximum | 95202 |
| Range | 95185 |
| Interquartile range | 276.25 |
Descriptive statistics
| Standard deviation | 4111.2 |
|---|---|
| Coef of variation | 7.0762 |
| Kurtosis | 499.53 |
| Mean | 580.98 |
| MAD | 662.11 |
| Skewness | 21.811 |
| Sum | 3.2884e+05 |
| Variance | 1.6902e+07 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 96 | 7 | 1.2% | |
| 98 | 7 | 1.2% | |
| 71 | 7 | 1.2% | |
| 94 | 6 | 1.1% | |
| 123 | 6 | 1.1% | |
| 142 | 6 | 1.1% | |
| 110 | 5 | 0.9% | |
| 77 | 5 | 0.9% | |
| 73 | 5 | 0.9% | |
| 79 | 4 | 0.7% | |
| Other values (341) | 508 | 89.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 17 | 1 | 0.2% | |
| 21 | 1 | 0.2% | |
| 38 | 1 | 0.2% | |
| 40 | 1 | 0.2% | |
| 42 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 95202 | 1 | 0.2% | |
| 17969 | 1 | 0.2% | |
| 6622 | 1 | 0.2% | |
| 6010 | 1 | 0.2% | |
| 5759 | 1 | 0.2% |
qt_ramos_coligados
Numeric
| Distinct count | 22 |
|---|---|
| Unique (%) | 3.9% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.1304 |
|---|---|
| Minimum | 1 |
| Maximum | 30 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 3 |
| Q3 | 5 |
| 95-th percentile | 12.1 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 4.1893 |
|---|---|
| Coef of variation | 1.0142 |
| Kurtosis | 11.049 |
| Mean | 4.1304 |
| MAD | 2.7887 |
| Skewness | 2.8221 |
| Sum | 1235 |
| Variance | 17.55 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 76 | 13.4% | |
| 2 | 54 | 9.5% | |
| 3 | 53 | 9.4% | |
| 4 | 31 | 5.5% | |
| 5 | 20 | 3.5% | |
| 7 | 14 | 2.5% | |
| 8 | 11 | 1.9% | |
| 6 | 10 | 1.8% | |
| 10 | 9 | 1.6% | |
| 15 | 3 | 0.5% | |
| Other values (11) | 18 | 3.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 76 | 13.4% | |
| 2 | 54 | 9.5% | |
| 3 | 53 | 9.4% | |
| 4 | 31 | 5.5% | |
| 5 | 20 | 3.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 30 | 2 | 0.4% | |
| 21 | 1 | 0.2% | |
| 19 | 1 | 0.2% | |
| 18 | 2 | 0.4% | |
| 17 | 1 | 0.2% |
qt_regioes_coligados
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.3445 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1.5 |
| 95-th percentile | 3 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range | 0.5 |
Descriptive statistics
| Standard deviation | 0.69398 |
|---|---|
| Coef of variation | 0.51617 |
| Kurtosis | 6.1631 |
| Mean | 1.3445 |
| MAD | 0.51615 |
| Skewness | 2.3901 |
| Sum | 402 |
| Variance | 0.48161 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 224 | 39.6% | |
| 2 | 56 | 9.9% | |
| 3 | 11 | 1.9% | |
| 4 | 7 | 1.2% | |
| 5 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 224 | 39.6% | |
| 2 | 56 | 9.9% | |
| 3 | 11 | 1.9% | |
| 4 | 7 | 1.2% | |
| 5 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1 | 0.2% | |
| 4 | 7 | 1.2% | |
| 3 | 11 | 1.9% | |
| 2 | 56 | 9.9% | |
| 1 | 224 | 39.6% |
qt_socios
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | 2.7% |
| Missing (%) | 32.5% |
| Missing (n) | 184 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.0995 |
|---|---|
| Minimum | 1 |
| Maximum | 139 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 2 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 139 |
| Range | 138 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 7.2366 |
|---|---|
| Coef of variation | 2.3348 |
| Kurtosis | 328.78 |
| Mean | 3.0995 |
| MAD | 1.6803 |
| Skewness | 17.547 |
| Sum | 1184 |
| Variance | 52.368 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 2 | 181 | 32.0% | |
| 3 | 65 | 11.5% | |
| 1 | 55 | 9.7% | |
| 4 | 42 | 7.4% | |
| 5 | 14 | 2.5% | |
| 6 | 13 | 2.3% | |
| 7 | 3 | 0.5% | |
| 9 | 3 | 0.5% | |
| 139 | 1 | 0.2% | |
| 13 | 1 | 0.2% | |
| Other values (4) | 4 | 0.7% | |
| (Missing) | 184 | 32.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 55 | 9.7% | |
| 2 | 181 | 32.0% | |
| 3 | 65 | 11.5% | |
| 4 | 42 | 7.4% | |
| 5 | 14 | 2.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 139 | 1 | 0.2% | |
| 22 | 1 | 0.2% | |
| 14 | 1 | 0.2% | |
| 13 | 1 | 0.2% | |
| 12 | 1 | 0.2% |
qt_socios_coligados
Highly correlated
This variable is highly correlated with qt_coligados_matriz and should be ignored for analysis
| Correlation | 0.96791 |
|---|
qt_socios_feminino
Highly correlated
This variable is highly correlated with qt_socios and should be ignored for analysis
| Correlation | 0.98778 |
|---|
qt_socios_masculino
Highly correlated
This variable is highly correlated with qt_socios_feminino and should be ignored for analysis
| Correlation | 0.96613 |
|---|
qt_socios_pep
Highly correlated
This variable is highly correlated with qt_socios_masculino and should be ignored for analysis
| Correlation | 0.97676 |
|---|
qt_socios_pf
Highly correlated
This variable is highly correlated with qt_socios_pep and should be ignored for analysis
| Correlation | 0.9745 |
|---|
qt_socios_pj
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.9% |
| Missing (%) | 32.5% |
| Missing (n) | 184 |
| 0 | |
|---|---|
| 1 | 35 |
| 2 | 15 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 331 | 58.5% | |
| 1 | 35 | 6.2% | |
| 2 | 15 | 2.7% | |
| 3 | 1 | 0.2% | |
| (Missing) | 184 | 32.5% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
qt_socios_pj_ativos
Highly correlated
This variable is highly correlated with qt_socios_pj and should be ignored for analysis
| Correlation | 0.96283 |
|---|
qt_socios_pj_baixados
Boolean
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 91.0% |
| Missing (n) | 515 |
| 0 | 50 |
|---|---|
| 1 | 1 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 50 | 8.8% | |
| 1 | 1 | 0.2% | |
| (Missing) | 515 | 91.0% |
qt_socios_pj_inaptos
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_socios_pj_nulos
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_socios_pj_suspensos
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0.0 |
|---|
qt_socios_st_regular
Highly correlated
This variable is highly correlated with qt_socios_pf and should be ignored for analysis
| Correlation | 0.99433 |
|---|
qt_socios_st_suspensa
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
qt_ufs_coligados
Numeric
| Distinct count | 12 |
|---|---|
| Unique (%) | 2.1% |
| Missing (%) | 47.2% |
| Missing (n) | 267 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.7458 |
|---|---|
| Minimum | 1 |
| Maximum | 11 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 11 |
| Range | 10 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.5573 |
|---|---|
| Coef of variation | 0.892 |
| Kurtosis | 14.305 |
| Mean | 1.7458 |
| MAD | 0.95784 |
| Skewness | 3.4833 |
| Sum | 522 |
| Variance | 2.4251 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 192 | 33.9% | |
| 2 | 64 | 11.3% | |
| 3 | 22 | 3.9% | |
| 5 | 6 | 1.1% | |
| 4 | 4 | 0.7% | |
| 6 | 3 | 0.5% | |
| 7 | 2 | 0.4% | |
| 11 | 2 | 0.4% | |
| 9 | 2 | 0.4% | |
| 10 | 1 | 0.2% | |
| (Missing) | 267 | 47.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 192 | 33.9% | |
| 2 | 64 | 11.3% | |
| 3 | 22 | 3.9% | |
| 4 | 4 | 0.7% | |
| 5 | 6 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 11 | 2 | 0.4% | |
| 10 | 1 | 0.2% | |
| 9 | 2 | 0.4% | |
| 8 | 1 | 0.2% | |
| 7 | 2 | 0.4% |
setor
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| SERVIÇO | |
|---|---|
| COMERCIO | |
| INDUSTRIA | |
| Other values (2) | 54 |
| Value | Count | Frequency (%) | |
| SERVIÇO | 336 | 59.4% | |
| COMERCIO | 107 | 18.9% | |
| INDUSTRIA | 69 | 12.2% | |
| CONSTRUÇÃO CIVIL | 46 | 8.1% | |
| AGROPECUARIA | 8 | 1.4% |
| Max length | 16 |
|---|---|
| Mean length | 8.235 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
sg_uf
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| AM | |
|---|---|
| MA | |
| PI | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| AM | 142 | 25.1% | |
| MA | 118 | 20.8% | |
| PI | 101 | 17.8% | |
| RN | 100 | 17.7% | |
| RO | 70 | 12.4% | |
| AC | 35 | 6.2% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
sg_uf_matriz
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| AM | |
|---|---|
| MA | |
| PI | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| AM | 142 | 25.1% | |
| MA | 118 | 20.8% | |
| PI | 101 | 17.8% | |
| RN | 100 | 17.7% | |
| RO | 70 | 12.4% | |
| AC | 35 | 6.2% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
sum_faturamento_estimado_coligadas
Highly correlated
This variable is highly correlated with faturamento_est_coligados_gp and should be ignored for analysis
| Correlation | 0.96717 |
|---|
total
Highly correlated
This variable is highly correlated with qt_funcionarios_24meses and should be ignored for analysis
| Correlation | 0.97843 |
|---|
total_filiais_coligados
Highly correlated
This variable is highly correlated with qt_funcionarios_coligados_gp and should be ignored for analysis
| Correlation | 0.92158 |
|---|
tx_crescimento_12meses
Numeric
| Distinct count | 355 |
|---|---|
| Unique (%) | 62.7% |
| Missing (%) | 0.2% |
| Missing (n) | 1 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.7448 |
|---|---|
| Minimum | -79.462 |
| Maximum | 376.32 |
| Zeros (%) | 34.5% |
Quantile statistics
| Minimum | -79.462 |
|---|---|
| 5-th percentile | -18.051 |
| Q1 | -0.98039 |
| Median | 0 |
| Q3 | 5 |
| 95-th percentile | 35.846 |
| Maximum | 376.32 |
| Range | 455.78 |
| Interquartile range | 5.9804 |
Descriptive statistics
| Standard deviation | 28.294 |
|---|---|
| Coef of variation | 5.9632 |
| Kurtosis | 74.962 |
| Mean | 4.7448 |
| MAD | 12.075 |
| Skewness | 6.9998 |
| Sum | 2680.8 |
| Variance | 800.55 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 195 | 34.5% | |
| 1.0638 | 3 | 0.5% | |
| 2.5641 | 3 | 0.5% | |
| 11.321 | 2 | 0.4% | |
| -6.8966 | 2 | 0.4% | |
| 21.905 | 2 | 0.4% | |
| -1.3514 | 2 | 0.4% | |
| 2.7027 | 2 | 0.4% | |
| 10.169 | 2 | 0.4% | |
| -2.0202 | 2 | 0.4% | |
| Other values (344) | 350 | 61.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -79.462 | 1 | 0.2% | |
| -65.948 | 1 | 0.2% | |
| -44.304 | 1 | 0.2% | |
| -41.27 | 1 | 0.2% | |
| -40.854 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 376.32 | 1 | 0.2% | |
| 290.48 | 1 | 0.2% | |
| 181.55 | 1 | 0.2% | |
| 133.33 | 1 | 0.2% | |
| 126.67 | 1 | 0.2% |
tx_crescimento_24meses
Highly correlated
This variable is highly correlated with qt_socios_pep and should be ignored for analysis
| Correlation | 0.96385 |
|---|
tx_rotatividade
Numeric
| Distinct count | 362 |
|---|---|
| Unique (%) | 64.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.801 |
|---|---|
| Minimum | 0 |
| Maximum | 133.88 |
| Zeros (%) | 33.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 8.4636 |
| Q3 | 19.84 |
| 95-th percentile | 46.42 |
| Maximum | 133.88 |
| Range | 133.88 |
| Interquartile range | 19.84 |
Descriptive statistics
| Standard deviation | 18.288 |
|---|---|
| Coef of variation | 1.3251 |
| Kurtosis | 8.8707 |
| Mean | 13.801 |
| MAD | 12.95 |
| Skewness | 2.4553 |
| Sum | 7811.1 |
| Variance | 334.44 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 188 | 33.2% | |
| 38.462 | 3 | 0.5% | |
| 22.642 | 2 | 0.4% | |
| 5.2288 | 2 | 0.4% | |
| 19.512 | 2 | 0.4% | |
| 27.586 | 2 | 0.4% | |
| 19.355 | 2 | 0.4% | |
| 10.909 | 2 | 0.4% | |
| 8.2759 | 2 | 0.4% | |
| 10.811 | 2 | 0.4% | |
| Other values (352) | 359 | 63.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 188 | 33.2% | |
| 0.027859 | 1 | 0.2% | |
| 0.13387 | 1 | 0.2% | |
| 0.14316 | 1 | 0.2% | |
| 0.28902 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 133.88 | 1 | 0.2% | |
| 114.43 | 1 | 0.2% | |
| 113.96 | 1 | 0.2% | |
| 106.67 | 1 | 0.2% | |
| 95.904 | 1 | 0.2% |
vl_faturamento_estimado_aux
Numeric
| Distinct count | 480 |
|---|---|
| Unique (%) | 84.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 8.1049e+07 |
|---|---|
| Minimum | 1.0015e+07 |
| Maximum | 3.4909e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.0015e+07 |
|---|---|
| 5-th percentile | 1.1024e+07 |
| Q1 | 1.8507e+07 |
| Median | 3.0406e+07 |
| Q3 | 6.3313e+07 |
| 95-th percentile | 2.9249e+08 |
| Maximum | 3.4909e+09 |
| Range | 3.4809e+09 |
| Interquartile range | 4.4806e+07 |
Descriptive statistics
| Standard deviation | 2.2205e+08 |
|---|---|
| Coef of variation | 2.7398 |
| Kurtosis | 119.27 |
| Mean | 8.1049e+07 |
| MAD | 8.2627e+07 |
| Skewness | 9.5819 |
| Sum | 4.5874e+10 |
| Variance | 4.9308e+16 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1.1024e+07 | 5 | 0.9% | |
| 1.9267e+07 | 5 | 0.9% | |
| 2.7355e+07 | 3 | 0.5% | |
| 1.1591e+07 | 3 | 0.5% | |
| 1.7515e+07 | 3 | 0.5% | |
| 1.2467e+07 | 3 | 0.5% | |
| 2.1328e+07 | 3 | 0.5% | |
| 1.0046e+07 | 3 | 0.5% | |
| 1.5764e+07 | 3 | 0.5% | |
| 1.1746e+07 | 3 | 0.5% | |
| Other values (470) | 532 | 94.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0015e+07 | 1 | 0.2% | |
| 1.0046e+07 | 3 | 0.5% | |
| 1.0097e+07 | 2 | 0.4% | |
| 1.0138e+07 | 1 | 0.2% | |
| 1.0149e+07 | 2 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.4909e+09 | 1 | 0.2% | |
| 2.0688e+09 | 1 | 0.2% | |
| 1.7005e+09 | 1 | 0.2% | |
| 1.5354e+09 | 1 | 0.2% | |
| 1.3759e+09 | 1 | 0.2% |
vl_faturamento_estimado_grupo_aux
Numeric
| Distinct count | 528 |
|---|---|
| Unique (%) | 93.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.99e+07 |
|---|---|
| Minimum | 1.0015e+07 |
| Maximum | 4.6638e+09 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.0015e+07 |
|---|---|
| 5-th percentile | 1.1552e+07 |
| Q1 | 2.0204e+07 |
| Median | 3.493e+07 |
| Q3 | 7.5112e+07 |
| 95-th percentile | 3.2661e+08 |
| Maximum | 4.6638e+09 |
| Range | 4.6538e+09 |
| Interquartile range | 5.4908e+07 |
Descriptive statistics
| Standard deviation | 3.0304e+08 |
|---|---|
| Coef of variation | 3.0334 |
| Kurtosis | 125.51 |
| Mean | 9.99e+07 |
| MAD | 1.0515e+08 |
| Skewness | 10.055 |
| Sum | 5.6543e+10 |
| Variance | 9.1831e+16 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1.1024e+07 | 5 | 0.9% | |
| 1.1746e+07 | 3 | 0.5% | |
| 2.7355e+07 | 3 | 0.5% | |
| 4.0955e+07 | 3 | 0.5% | |
| 1.0921e+07 | 3 | 0.5% | |
| 3.0497e+07 | 3 | 0.5% | |
| 1.2312e+07 | 2 | 0.4% | |
| 2.1328e+07 | 2 | 0.4% | |
| 4.0131e+07 | 2 | 0.4% | |
| 1.0097e+07 | 2 | 0.4% | |
| Other values (518) | 538 | 95.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.0015e+07 | 1 | 0.2% | |
| 1.0046e+07 | 2 | 0.4% | |
| 1.0097e+07 | 2 | 0.4% | |
| 1.0138e+07 | 1 | 0.2% | |
| 1.0406e+07 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4.6638e+09 | 1 | 0.2% | |
| 3.52e+09 | 1 | 0.2% | |
| 2.0777e+09 | 1 | 0.2% | |
| 1.7005e+09 | 1 | 0.2% | |
| 1.5545e+09 | 1 | 0.2% |
vl_folha_coligados
Highly correlated
This variable is highly correlated with qt_funcionarios_coligados and should be ignored for analysis
| Correlation | 0.92165 |
|---|
vl_folha_coligados_gp
Highly correlated
This variable is highly correlated with max_vl_folha_coligados_gp and should be ignored for analysis
| Correlation | 0.90572 |
|---|
vl_frota
Numeric
| Distinct count | 467 |
|---|---|
| Unique (%) | 82.5% |
| Missing (%) | 17.3% |
| Missing (n) | 98 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.6479e+05 |
|---|---|
| Minimum | 3435 |
| Maximum | 3.832e+07 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 3435 |
|---|---|
| 5-th percentile | 25751 |
| Q1 | 1.0064e+05 |
| Median | 2.9737e+05 |
| Q3 | 6.3126e+05 |
| 95-th percentile | 3.7128e+06 |
| Maximum | 3.832e+07 |
| Range | 3.8317e+07 |
| Interquartile range | 5.3062e+05 |
Descriptive statistics
| Standard deviation | 2.7903e+06 |
|---|---|
| Coef of variation | 2.8922 |
| Kurtosis | 78.569 |
| Mean | 9.6479e+05 |
| MAD | 1.1407e+06 |
| Skewness | 7.5687 |
| Sum | 4.5152e+08 |
| Variance | 7.7859e+12 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1.739e+05 | 2 | 0.4% | |
| 64657 | 2 | 0.4% | |
| 2.7255e+05 | 1 | 0.2% | |
| 40655 | 1 | 0.2% | |
| 59795 | 1 | 0.2% | |
| 5.8706e+05 | 1 | 0.2% | |
| 3.0684e+05 | 1 | 0.2% | |
| 2.5454e+05 | 1 | 0.2% | |
| 6.7206e+05 | 1 | 0.2% | |
| 34236 | 1 | 0.2% | |
| Other values (456) | 456 | 80.6% | |
| (Missing) | 98 | 17.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 3435 | 1 | 0.2% | |
| 3611 | 1 | 0.2% | |
| 3705 | 1 | 0.2% | |
| 4361 | 1 | 0.2% | |
| 4610 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3.832e+07 | 1 | 0.2% | |
| 1.866e+07 | 1 | 0.2% | |
| 1.6423e+07 | 1 | 0.2% | |
| 1.5787e+07 | 1 | 0.2% | |
| 1.5604e+07 | 1 | 0.2% |
vl_idade_maxima_socios_pj
Numeric
| Distinct count | 51 |
|---|---|
| Unique (%) | 9.0% |
| Missing (%) | 91.0% |
| Missing (n) | 515 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.374 |
|---|---|
| Minimum | 0.76112 |
| Maximum | 52.282 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.76112 |
|---|---|
| 5-th percentile | 1.6605 |
| Q1 | 4.1821 |
| Median | 7.102 |
| Q3 | 18.658 |
| 95-th percentile | 39.648 |
| Maximum | 52.282 |
| Range | 51.521 |
| Interquartile range | 14.476 |
Descriptive statistics
| Standard deviation | 12.985 |
|---|---|
| Coef of variation | 0.9709 |
| Kurtosis | 1.3448 |
| Mean | 13.374 |
| MAD | 10.24 |
| Skewness | 1.4101 |
| Sum | 682.1 |
| Variance | 168.62 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 15.343 | 2 | 0.4% | |
| 17.298 | 1 | 0.2% | |
| 4.0794 | 1 | 0.2% | |
| 3.5565 | 1 | 0.2% | |
| 12.159 | 1 | 0.2% | |
| 34.242 | 1 | 0.2% | |
| 19.121 | 1 | 0.2% | |
| 2.0616 | 1 | 0.2% | |
| 0.8679 | 1 | 0.2% | |
| 15.439 | 1 | 0.2% | |
| Other values (40) | 40 | 7.1% | |
| (Missing) | 515 | 91.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.76112 | 1 | 0.2% | |
| 0.8679 | 1 | 0.2% | |
| 1.3388 | 1 | 0.2% | |
| 1.9822 | 1 | 0.2% | |
| 2.0616 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 52.282 | 1 | 0.2% | |
| 49.374 | 1 | 0.2% | |
| 41.402 | 1 | 0.2% | |
| 37.895 | 1 | 0.2% | |
| 34.242 | 1 | 0.2% |
vl_idade_media_socios_pj
Highly correlated
This variable is highly correlated with vl_idade_maxima_socios_pj and should be ignored for analysis
| Correlation | 0.93323 |
|---|
vl_idade_minima_socios_pj
Highly correlated
This variable is highly correlated with vl_idade_media_socios_pj and should be ignored for analysis
| Correlation | 0.92519 |
|---|
vl_potenc_cons_oleo_gas
Numeric
| Distinct count | 62 |
|---|---|
| Unique (%) | 11.0% |
| Missing (%) | 83.4% |
| Missing (n) | 472 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 78.468 |
|---|---|
| Minimum | 1 |
| Maximum | 1080 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 14.25 |
| Median | 44.5 |
| Q3 | 81.5 |
| 95-th percentile | 308.45 |
| Maximum | 1080 |
| Range | 1079 |
| Interquartile range | 67.25 |
Descriptive statistics
| Standard deviation | 136.42 |
|---|---|
| Coef of variation | 1.7385 |
| Kurtosis | 31.586 |
| Mean | 78.468 |
| MAD | 73.751 |
| Skewness | 4.8865 |
| Sum | 7376 |
| Variance | 18610 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 45 | 8 | 1.4% | |
| 6 | 5 | 0.9% | |
| 4 | 5 | 0.9% | |
| 18 | 4 | 0.7% | |
| 20 | 3 | 0.5% | |
| 3 | 3 | 0.5% | |
| 7 | 3 | 0.5% | |
| 60 | 3 | 0.5% | |
| 30 | 2 | 0.4% | |
| 2 | 2 | 0.4% | |
| Other values (51) | 56 | 9.9% | |
| (Missing) | 472 | 83.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.2% | |
| 2 | 2 | 0.4% | |
| 3 | 3 | 0.5% | |
| 4 | 5 | 0.9% | |
| 5 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1080 | 1 | 0.2% | |
| 430 | 1 | 0.2% | |
| 380 | 1 | 0.2% | |
| 374 | 1 | 0.2% | |
| 352 | 1 | 0.2% |
vl_total_tancagem
Highly correlated
This variable is highly correlated with vl_potenc_cons_oleo_gas and should be ignored for analysis
| Correlation | 0.94313 |
|---|
vl_total_tancagem_grupo
Numeric
| Distinct count | 11 |
|---|---|
| Unique (%) | 1.9% |
| Missing (%) | 94.7% |
| Missing (n) | 536 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 45.867 |
|---|---|
| Minimum | 10 |
| Maximum | 385 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 15 |
| Median | 17.5 |
| Q3 | 30 |
| 95-th percentile | 177.5 |
| Maximum | 385 |
| Range | 375 |
| Interquartile range | 15 |
Descriptive statistics
| Standard deviation | 78.134 |
|---|---|
| Coef of variation | 1.7035 |
| Kurtosis | 13.537 |
| Mean | 45.867 |
| MAD | 42.169 |
| Skewness | 3.6079 |
| Sum | 1376 |
| Variance | 6104.9 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 15 | 14 | 2.5% | |
| 30 | 5 | 0.9% | |
| 20 | 3 | 0.5% | |
| 45 | 2 | 0.4% | |
| 245 | 1 | 0.2% | |
| 385 | 1 | 0.2% | |
| 10 | 1 | 0.2% | |
| 91 | 1 | 0.2% | |
| 95 | 1 | 0.2% | |
| 40 | 1 | 0.2% | |
| (Missing) | 536 | 94.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 10 | 1 | 0.2% | |
| 15 | 14 | 2.5% | |
| 20 | 3 | 0.5% | |
| 30 | 5 | 0.9% | |
| 40 | 1 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 385 | 1 | 0.2% | |
| 245 | 1 | 0.2% | |
| 95 | 1 | 0.2% | |
| 91 | 1 | 0.2% | |
| 45 | 2 | 0.4% |
vl_total_veiculos_antt
Highly correlated
This variable is highly correlated with vl_total_tancagem_grupo and should be ignored for analysis
| Correlation | 0.9644 |
|---|
vl_total_veiculos_antt_grupo
Highly correlated
This variable is highly correlated with vl_total_veiculos_antt and should be ignored for analysis
| Correlation | 1 |
|---|
vl_total_veiculos_leves
Numeric
| Distinct count | 59 |
|---|---|
| Unique (%) | 10.4% |
| Missing (%) | 13.4% |
| Missing (n) | 76 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 11.645 |
|---|---|
| Minimum | 0 |
| Maximum | 359 |
| Zeros (%) | 8.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| Median | 5 |
| Q3 | 10 |
| 95-th percentile | 41.55 |
| Maximum | 359 |
| Range | 359 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 27.507 |
|---|---|
| Coef of variation | 2.3621 |
| Kurtosis | 64.13 |
| Mean | 11.645 |
| MAD | 12.088 |
| Skewness | 6.8574 |
| Sum | 5706 |
| Variance | 756.62 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 1 | 61 | 10.8% | |
| 2 | 51 | 9.0% | |
| 0 | 47 | 8.3% | |
| 3 | 46 | 8.1% | |
| 5 | 38 | 6.7% | |
| 4 | 33 | 5.8% | |
| 6 | 23 | 4.1% | |
| 7 | 23 | 4.1% | |
| 10 | 19 | 3.4% | |
| 9 | 17 | 3.0% | |
| Other values (48) | 132 | 23.3% | |
| (Missing) | 76 | 13.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 47 | 8.3% | |
| 1 | 61 | 10.8% | |
| 2 | 51 | 9.0% | |
| 3 | 46 | 8.1% | |
| 4 | 33 | 5.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 359 | 1 | 0.2% | |
| 194 | 1 | 0.2% | |
| 170 | 1 | 0.2% | |
| 167 | 1 | 0.2% | |
| 164 | 1 | 0.2% |
vl_total_veiculos_leves_grupo
Highly correlated
This variable is highly correlated with vl_total_veiculos_leves and should be ignored for analysis
| Correlation | 0.95902 |
|---|
vl_total_veiculos_pesados
Numeric
| Distinct count | 59 |
|---|---|
| Unique (%) | 10.4% |
| Missing (%) | 13.4% |
| Missing (n) | 76 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.849 |
|---|---|
| Minimum | 0 |
| Maximum | 215 |
| Zeros (%) | 29.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 2 |
| Q3 | 8 |
| 95-th percentile | 46 |
| Maximum | 215 |
| Range | 215 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 24.115 |
|---|---|
| Coef of variation | 2.4485 |
| Kurtosis | 30.729 |
| Mean | 9.849 |
| MAD | 12.202 |
| Skewness | 5.0185 |
| Sum | 4826 |
| Variance | 581.52 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 165 | 29.2% | |
| 1 | 55 | 9.7% | |
| 2 | 42 | 7.4% | |
| 3 | 29 | 5.1% | |
| 4 | 24 | 4.2% | |
| 7 | 19 | 3.4% | |
| 5 | 15 | 2.7% | |
| 9 | 14 | 2.5% | |
| 6 | 13 | 2.3% | |
| 8 | 11 | 1.9% | |
| Other values (48) | 103 | 18.2% | |
| (Missing) | 76 | 13.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 165 | 29.2% | |
| 1 | 55 | 9.7% | |
| 2 | 42 | 7.4% | |
| 3 | 29 | 5.1% | |
| 4 | 24 | 4.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 215 | 1 | 0.2% | |
| 190 | 1 | 0.2% | |
| 187 | 1 | 0.2% | |
| 176 | 1 | 0.2% | |
| 142 | 1 | 0.2% |
vl_total_veiculos_pesados_grupo
Numeric
| Distinct count | 65 |
|---|---|
| Unique (%) | 11.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 10.408 |
|---|---|
| Minimum | 0 |
| Maximum | 663 |
| Zeros (%) | 41.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 7 |
| 95-th percentile | 46 |
| Maximum | 663 |
| Range | 663 |
| Interquartile range | 7 |
Descriptive statistics
| Standard deviation | 36.866 |
|---|---|
| Coef of variation | 3.542 |
| Kurtosis | 179.17 |
| Mean | 10.408 |
| MAD | 13.944 |
| Skewness | 11.328 |
| Sum | 5891 |
| Variance | 1359.1 |
| Memory size | 28.8 KiB |
| Value | Count | Frequency (%) | |
| 0 | 237 | 41.9% | |
| 1 | 54 | 9.5% | |
| 2 | 41 | 7.2% | |
| 3 | 28 | 4.9% | |
| 4 | 25 | 4.4% | |
| 5 | 17 | 3.0% | |
| 7 | 16 | 2.8% | |
| 6 | 15 | 2.7% | |
| 9 | 13 | 2.3% | |
| 10 | 10 | 1.8% | |
| Other values (55) | 110 | 19.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 237 | 41.9% | |
| 1 | 54 | 9.5% | |
| 2 | 41 | 7.2% | |
| 3 | 28 | 4.9% | |
| 4 | 25 | 4.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 663 | 1 | 0.2% | |
| 215 | 1 | 0.2% | |
| 190 | 1 | 0.2% | |
| 187 | 1 | 0.2% | |
| 179 | 1 | 0.2% |
First rows
| coligada_mais_antiga_ativa | coligada_mais_antiga_baixada | coligada_mais_nova_ativa | coligada_mais_nova_baixada | de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_indicador_telefone | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | faturamento_est_coligados | faturamento_est_coligados_gp | fl_antt | fl_email | fl_epp | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | grau_instrucao_macro_analfabeto | grau_instrucao_macro_desconhecido | grau_instrucao_macro_escolaridade_fundamental | grau_instrucao_macro_escolaridade_media | grau_instrucao_macro_escolaridade_superior | id | idade_acima_de_58 | idade_ate_18 | idade_de_19_a_23 | idade_de_24_a_28 | idade_de_29_a_33 | idade_de_34_a_38 | idade_de_39_a_43 | idade_de_44_a_48 | idade_de_49_a_53 | idade_de_54_a_58 | idade_emp_cat | idade_empresa_anos | idade_maxima_coligadas | idade_maxima_socios | idade_media_coligadas | idade_media_coligadas_ativas | idade_media_coligadas_baixadas | idade_media_socios | idade_minima_coligadas | idade_minima_socios | max_faturamento_est_coligados | max_faturamento_est_coligados_gp | max_filiais_coligados | max_funcionarios_coligados_gp | max_meses_servicos | max_meses_servicos_all | max_vl_folha_coligados | max_vl_folha_coligados_gp | media_faturamento_est_coligados | media_faturamento_est_coligados_gp | media_filiais_coligados | media_funcionarios_coligados_gp | media_meses_servicos | media_meses_servicos_all | media_vl_folha_coligados | media_vl_folha_coligados_gp | meses_ultima_contratacaco | min_faturamento_est_coligados | min_faturamento_est_coligados_gp | min_filiais_coligados | min_funcionarios_coligados_gp | min_meses_servicos | min_meses_servicos_all | min_vl_folha_coligados | min_vl_folha_coligados_gp | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | percent_func_genero_fem | percent_func_genero_masc | qt_admitidos | qt_admitidos_12meses | qt_alteracao_socio_180d | qt_alteracao_socio_365d | qt_alteracao_socio_90d | qt_alteracao_socio_total | qt_art | qt_coligadas | qt_coligados | qt_coligados_agropecuaria | qt_coligados_atividade_alto | qt_coligados_atividade_baixo | qt_coligados_atividade_inativo | qt_coligados_atividade_medio | qt_coligados_atividade_mt_baixo | qt_coligados_ativo | qt_coligados_baixada | qt_coligados_ccivil | qt_coligados_centro | qt_coligados_comercio | qt_coligados_epp | qt_coligados_exterior | qt_coligados_inapta | qt_coligados_industria | qt_coligados_ltda | qt_coligados_matriz | qt_coligados_me | qt_coligados_mei | qt_coligados_nordeste | qt_coligados_norte | qt_coligados_nula | qt_coligados_sa | qt_coligados_serviço | qt_coligados_sudeste | qt_coligados_sul | qt_coligados_suspensa | qt_desligados | qt_desligados_12meses | qt_ex_funcionarios | qt_filiais | qt_funcionarios | qt_funcionarios_12meses | qt_funcionarios_24meses | qt_funcionarios_coligados | qt_funcionarios_coligados_gp | qt_funcionarios_grupo | qt_ramos_coligados | qt_regioes_coligados | qt_socios | qt_socios_coligados | qt_socios_feminino | qt_socios_masculino | qt_socios_pep | qt_socios_pf | qt_socios_pj | qt_socios_pj_ativos | qt_socios_pj_baixados | qt_socios_pj_inaptos | qt_socios_pj_nulos | qt_socios_pj_suspensos | qt_socios_st_regular | qt_socios_st_suspensa | qt_ufs_coligados | setor | sg_uf | sg_uf_matriz | sum_faturamento_estimado_coligadas | total | total_filiais_coligados | tx_crescimento_12meses | tx_crescimento_24meses | tx_rotatividade | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_folha_coligados | vl_folha_coligados_gp | vl_frota | vl_idade_maxima_socios_pj | vl_idade_media_socios_pj | vl_idade_minima_socios_pj | vl_potenc_cons_oleo_gas | vl_total_tancagem | vl_total_tancagem_grupo | vl_total_veiculos_antt | vl_total_veiculos_antt_grupo | vl_total_veiculos_leves | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | NaN | NaN | NaN | DE R$ 300.000.000,01 A R$ 500.000.000,00 | DE R$ 300.000.000,01 A R$ 500.000.000,00 | BOA | AUTARQUIA ESTADUAL OU DO DISTRITO FEDERAL | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2007-08-03 | 2791.15 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 2.0 | 523.0 | 836.0 | 09e95c1a84049001d086470a8f320a19b076f955a89122ff8360ac2e4d6eca5d | 2.0 | NaN | NaN | 23.0 | 411.0 | 508.0 | 282.0 | 103.0 | 22.0 | 10.0 | 10 a 15 | 11.243836 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 357.066667 | 357.066667 | NaN | NaN | NaN | NaN | NaN | NaN | 99.961009 | 84.967827 | NaN | NaN | 25.533333 | NaN | NaN | NaN | NaN | 25.533333 | -6.500000 | NaN | NaN | ADMINISTRACAO PUBLICA | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | VALE DO ACRE | RIO BRANCO | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 18.22 | 81.78 | 1812.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 451.0 | 0.0 | 451.0 | 0 | 1361.0 | 1361.0 | 1383.0 | NaN | NaN | 1361.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | AC | AC | NaN | 1361.0 | NaN | 0.000000 | -1.590745 | 0.000000 | 327487200.0 | 327487200.0 | NaN | NaN | 46132.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4.0 | 4.0 | 0.0 | 0.0 |
| 1 | NaN | NaN | NaN | NaN | DE R$ 100.000.000,01 A R$ 300.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | BOA | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2004-12-11 | 1007.87 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | NaN | NaN | 54.0 | 414.0 | 523.0 | dc9d155f5bcd3172031e2ec9431786e8871ff4b0ff4728bb62194ca0842cce3e | 123.0 | NaN | 11.0 | 59.0 | 104.0 | 157.0 | 129.0 | 163.0 | 113.0 | 132.0 | > 20 | 43.789041 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 526.133333 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 149.173091 | 80.756709 | NaN | NaN | 23.200000 | NaN | NaN | NaN | NaN | 23.200000 | -9.233333 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | AGRESTE POTIGUAR | AGRESTE POTIGUAR | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 57.11 | 42.89 | 2352.0 | 0.0 | NaN | NaN | NaN | NaN | 8.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1361.0 | 0.0 | 1359.0 | 0 | 991.0 | 991.0 | 1306.0 | NaN | NaN | 991.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RN | RN | NaN | 991.0 | NaN | 0.000000 | -24.119449 | 0.000000 | 176802910.0 | 176802910.0 | NaN | NaN | 1309391.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 20.0 | 20.0 | 16.0 | 16.0 |
| 2 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE SIMPLES LIMITADA | ALTA | SERVICOS DE EDUCACAO | ACIMA DE 1 ANO | VERDE | 2005-09-24 | 688.31 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 19.0 | 9.0 | 91.0 | 16843c9ffb920170477118933798510d8d5f00f5c56c1221773356355bded321 | 2.0 | NaN | 1.0 | 10.0 | 27.0 | 30.0 | 20.0 | 15.0 | 11.0 | 3.0 | 15 a 20 | 16.389041 | NaN | 70.0 | NaN | NaN | NaN | 70.000000 | NaN | 70.0 | NaN | NaN | NaN | NaN | 149.033333 | 149.033333 | NaN | NaN | NaN | NaN | NaN | NaN | 65.942017 | 42.166782 | NaN | NaN | 4.866667 | NaN | NaN | NaN | NaN | 4.866667 | 0.000000 | NaN | NaN | ENTIDADES EMPRESARIAIS | EDUCACAO | NORTE PIAUIENSE | BAIXO PARNAIBA PIAUIENSE | EDUCACAO | 23.0 | 47.90 | 52.10 | 291.0 | 21.0 | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 172.0 | 7.0 | 172.0 | 0 | 119.0 | 104.0 | 113.0 | NaN | NaN | 119.0 | NaN | NaN | 2.0 | NaN | 1.0 | NaN | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | SERVIÇO | PI | PI | NaN | 119.0 | NaN | 14.423077 | 5.309735 | 6.250000 | 27818640.0 | 27818640.0 | NaN | NaN | 60101.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 1.0 | 1.0 |
| 3 | NaN | NaN | NaN | NaN | DE R$ 100.000.000,01 A R$ 300.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | NaN | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | VERDE | 2005-09-24 | 1397.47 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | False | NaN | NaN | 8.0 | 22.0 | 1794.0 | ff045934d90aab184dd15e66daf3b3c97193bda5449298784b664681610609a0 | 143.0 | NaN | 16.0 | 90.0 | 213.0 | 352.0 | 382.0 | 264.0 | 199.0 | 165.0 | > 20 | 39.671233 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 555.766667 | 555.766667 | NaN | NaN | NaN | NaN | NaN | NaN | 144.013013 | 140.449941 | NaN | NaN | 28.300000 | NaN | NaN | NaN | NaN | 28.300000 | 0.966667 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | SUDOESTE AMAZONENSE | ALTO SOLIMOES | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 51.97 | 48.03 | 1971.0 | 0.0 | NaN | NaN | NaN | NaN | 11.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 142.0 | 0.0 | 141.0 | 1 | 1829.0 | 1829.0 | 1875.0 | NaN | NaN | 1824.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | AM | AM | NaN | 1824.0 | NaN | 0.000000 | -2.453333 | 0.000000 | 221518800.0 | 221518800.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 4 | 372.066667 | NaN | 172.400000 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | NaN | SOCIEDADE EMPRESARIA LIMITADA | ALTA | PRODUTOS DE AGROPECUARIA | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 707.20 | 14789028.0 | 16899028.0 | True | False | False | False | True | False | False | False | False | True | NAO | False | False | False | False | False | True | 14.0 | NaN | 153.0 | 5.0 | 3.0 | a0ce528caab2c62497a548d0ebd9e935143ef81ed7dbf074dcd7e0c7dd50ae11 | 1.0 | 3.0 | 21.0 | 19.0 | 26.0 | 23.0 | 31.0 | 26.0 | 14.0 | 11.0 | > 20 | 20.268493 | 372.066667 | 70.0 | 243.600000 | 243.600000 | NaN | 48.666667 | 172.400000 | 36.0 | 10148652.0 | 12258652.0 | 1.0 | 65.0 | 134.833333 | 179.766667 | 4059460.8 | 4059460.8 | 4929676.0 | 5.633009e+06 | 1.0 | 61.5 | 14.610734 | 11.000869 | 2.915806e+06 | 2.915806e+06 | 2.933333 | 210000.0 | 210000.0 | 1.0 | 58.0 | 2.933333 | -0.566667 | 1772150.4 | 1772150.4 | ENTIDADES EMPRESARIAIS | AGRICULTURA PECUARIA E SERVICOS RELACIONADOS | OESTE POTIGUAR | MOSSORO | AGRICULTURA PECUARIA PRODUCAO FLORESTAL PESCA E AQUICULTURA | 23.0 | 5.14 | 94.86 | 614.0 | 110.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 437.0 | 63.0 | 435.0 | 0 | 177.0 | 130.0 | 120.0 | 123.0 | 123.0 | 175.0 | 1.0 | 1.0 | 4.0 | 4.0 | NaN | 3.0 | NaN | 4.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | NaN | 1.0 | AGROPECUARIA | RN | RN | 14789028.0 | 175.0 | 1.0 | 36.153846 | 47.500000 | 41.042345 | 28127736.0 | 28127736.0 | 5831611.125 | 5831611.125 | 488926.0 | NaN | NaN | NaN | 6.0 | NaN | NaN | NaN | NaN | 12.0 | 12.0 | 3.0 | 3.0 |
| 5 | 92.100000 | NaN | 92.100000 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS ADMINISTRATIVOS | ACIMA DE 1 ANO | VERDE | 2005-09-24 | 2508.11 | 930000.0 | 1140000.0 | True | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 3.0 | 128.0 | 4.0 | 77ed856930ed9c2b5348eca951d152b5655c98af3bb44616674eaaa17846c7c7 | NaN | 3.0 | 22.0 | 32.0 | 29.0 | 27.0 | 15.0 | 3.0 | 3.0 | 1.0 | > 20 | 20.030137 | 92.100000 | 61.0 | 92.100000 | 92.100000 | NaN | 46.500000 | 92.100000 | 32.0 | 930000.0 | 1140000.0 | 1.0 | 0.0 | 48.733333 | 48.733333 | NaN | NaN | 930000.0 | 1.140000e+06 | 1.0 | 0.0 | 39.171605 | 17.072138 | NaN | NaN | 22.700000 | 930000.0 | 1140000.0 | 1.0 | 0.0 | 23.466667 | -0.500000 | NaN | NaN | ENTIDADES EMPRESARIAIS | SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO E OUTROS SERVICOS PRESTADOS PRINCIPALMENTE AS EMPRESAS | VALE DO ACRE | RIO BRANCO | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 48.0 | 49.63 | 50.37 | 396.0 | 0.0 | NaN | NaN | NaN | NaN | 2.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 261.0 | 0.0 | 261.0 | 7 | 135.0 | 135.0 | 189.0 | 0.0 | 0.0 | 135.0 | 1.0 | 1.0 | 2.0 | 1.0 | 1.0 | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | AC | AC | 930000.0 | 135.0 | 1.0 | 0.000000 | -28.571429 | 0.000000 | 19679112.0 | 19679112.0 | NaN | NaN | 141536.0 | NaN | NaN | NaN | 6.0 | NaN | NaN | NaN | NaN | 2.0 | 4.0 | 3.0 | 3.0 |
| 6 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | CONDOMINIO EDILICIO | ALTA | SERVICOS ADMINISTRATIVOS | ACIMA DE 1 ANO | VERDE | 1999-12-06 | 1185.57 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | False | NaN | NaN | 4.0 | 77.0 | 25.0 | 099927213e8cf60291e8241bc78a1d92da8fbb2826ae30b45cad02dcc2ea19ba | 3.0 | NaN | 9.0 | 15.0 | 18.0 | 24.0 | 22.0 | 4.0 | 8.0 | 3.0 | 15 a 20 | 18.906849 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 322.200000 | 5027.166667 | NaN | NaN | NaN | NaN | NaN | NaN | 93.833962 | 78.721077 | NaN | NaN | 3.933333 | NaN | NaN | NaN | NaN | 3.933333 | -0.533333 | NaN | NaN | ENTIDADES SEM FINS LUCRATIVOS | SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS | LESTE POTIGUAR | NATAL | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 23.0 | 27.36 | 72.64 | 514.0 | 11.0 | NaN | NaN | NaN | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 408.0 | 24.0 | 407.0 | 0 | 106.0 | 119.0 | 199.0 | NaN | NaN | 106.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RN | RN | NaN | 106.0 | NaN | -10.924370 | -46.733668 | 21.333333 | 18700308.0 | 18700308.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 7 | 110.933333 | NaN | 110.933333 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | COMERCIO POR ATACADO | ACIMA DE 1 ANO | VERDE | 2004-12-24 | 1374.23 | 210000.0 | 210000.0 | True | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 4.0 | 21.0 | 17.0 | d85ce0e92df9ddc051b211f1a5e3d9f223d7efd4c992459acf257316ad43609c | 2.0 | NaN | 5.0 | 5.0 | 12.0 | 12.0 | 3.0 | NaN | 1.0 | 2.0 | > 20 | 21.947945 | 110.933333 | 58.0 | 110.933333 | 110.933333 | NaN | 44.000000 | 110.933333 | 30.0 | 210000.0 | 210000.0 | NaN | NaN | 212.933333 | 212.933333 | NaN | NaN | 210000.0 | 2.100000e+05 | NaN | NaN | 78.924031 | 39.840373 | NaN | NaN | 3.933333 | 210000.0 | 210000.0 | NaN | NaN | 3.933333 | -0.566667 | NaN | NaN | ENTIDADES EMPRESARIAIS | COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS | NaN | NaN | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 24.0 | 35.71 | 64.29 | 161.0 | 7.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 118.0 | 14.0 | 118.0 | 5 | 43.0 | 52.0 | 58.0 | NaN | NaN | 57.0 | 1.0 | 1.0 | 4.0 | 1.0 | 1.0 | 1.0 | NaN | 4.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | COMERCIO | RO | RO | 210000.0 | 42.0 | NaN | -17.307692 | -25.862069 | 30.107527 | 10261987.0 | 13538405.0 | NaN | NaN | 672056.0 | NaN | NaN | NaN | 6.0 | NaN | NaN | NaN | NaN | 13.0 | 13.0 | 3.0 | 3.0 |
| 8 | 45.666667 | NaN | 45.666667 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | COMERCIO VAREJISTA | ACIMA DE 1 ANO | VERDE | 2004-04-24 | NaN | 210000.0 | 210000.0 | False | False | False | False | True | False | False | False | False | False | NAO | False | False | False | False | False | True | NaN | NaN | 14.0 | 64.0 | 16.0 | ccbfe46d5e42b751ffe2a742680e853f50ac12e9399c2ecc0538d68f5c1ed6b2 | NaN | 5.0 | 16.0 | 28.0 | 16.0 | 11.0 | 13.0 | 1.0 | 2.0 | 2.0 | 15 a 20 | 19.610959 | 45.666667 | 45.0 | 45.666667 | 45.666667 | NaN | 41.666667 | 45.666667 | 39.0 | 210000.0 | 210000.0 | NaN | NaN | 170.300000 | 170.300000 | NaN | NaN | 210000.0 | 2.100000e+05 | NaN | NaN | 48.918440 | 24.691643 | NaN | NaN | 2.166667 | 210000.0 | 210000.0 | NaN | NaN | 2.166667 | -0.433333 | NaN | NaN | ENTIDADES EMPRESARIAIS | COMERCIO VAREJISTA | NaN | NaN | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 26.0 | 23.40 | 76.60 | 352.0 | 28.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 258.0 | 20.0 | 258.0 | 1 | 94.0 | 87.0 | 99.0 | NaN | NaN | 94.0 | 1.0 | 1.0 | 3.0 | 1.0 | 1.0 | 2.0 | NaN | 3.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | NaN | 1.0 | COMERCIO | RO | RO | 210000.0 | 94.0 | NaN | 8.045977 | -5.050505 | 22.222222 | 26067096.0 | 26277096.0 | NaN | NaN | 217142.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11.0 | 11.0 | 5.0 | 5.0 |
| 9 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | MUNICIPIO | ALTA | ADMINISTRACAO PUBLICA, DEFESA E SEGURIDADE SOCIAL | ACIMA DE 1 ANO | AZUL | 2005-10-14 | 353.66 | NaN | NaN | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | NaN | NaN | 35.0 | 53.0 | 63.0 | 3aafa3a1f12f483740a52956af100223333d0e3c79bf2ce341896dd554e72293 | 14.0 | NaN | NaN | NaN | 8.0 | 18.0 | 29.0 | 22.0 | 31.0 | 29.0 | > 20 | 43.854795 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 506.966667 | 5014.966667 | NaN | NaN | NaN | NaN | NaN | NaN | 189.020309 | 316.503220 | NaN | NaN | 31.333333 | NaN | NaN | NaN | NaN | 31.333333 | 8.733333 | NaN | NaN | OUTROS | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | CENTRO NORTE PIAUIENSE | VALENCA DO PIAUI | ADMINISTRACAO PUBLICA DEFESA E SEGURIDADE SOCIAL | 23.0 | 73.51 | 26.49 | 176.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 25.0 | 0.0 | 25.0 | 0 | 151.0 | 151.0 | 151.0 | NaN | NaN | 151.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | PI | PI | NaN | 151.0 | NaN | 0.000000 | 0.000000 | 0.000000 | 24418584.0 | 24418584.0 | NaN | NaN | 87223.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 2.0 | 2.0 |
Last rows
| coligada_mais_antiga_ativa | coligada_mais_antiga_baixada | coligada_mais_nova_ativa | coligada_mais_nova_baixada | de_faixa_faturamento_estimado | de_faixa_faturamento_estimado_grupo | de_indicador_telefone | de_natureza_juridica | de_nivel_atividade | de_ramo | de_saude_rescencia | de_saude_tributaria | dt_situacao | empsetorcensitariofaixarendapopulacao | faturamento_est_coligados | faturamento_est_coligados_gp | fl_antt | fl_email | fl_epp | fl_ltda | fl_matriz | fl_me | fl_mei | fl_optante_simei | fl_optante_simples | fl_passivel_iss | fl_rm | fl_sa | fl_simples_irregular | fl_spa | fl_st_especial | fl_telefone | fl_veiculo | grau_instrucao_macro_analfabeto | grau_instrucao_macro_desconhecido | grau_instrucao_macro_escolaridade_fundamental | grau_instrucao_macro_escolaridade_media | grau_instrucao_macro_escolaridade_superior | id | idade_acima_de_58 | idade_ate_18 | idade_de_19_a_23 | idade_de_24_a_28 | idade_de_29_a_33 | idade_de_34_a_38 | idade_de_39_a_43 | idade_de_44_a_48 | idade_de_49_a_53 | idade_de_54_a_58 | idade_emp_cat | idade_empresa_anos | idade_maxima_coligadas | idade_maxima_socios | idade_media_coligadas | idade_media_coligadas_ativas | idade_media_coligadas_baixadas | idade_media_socios | idade_minima_coligadas | idade_minima_socios | max_faturamento_est_coligados | max_faturamento_est_coligados_gp | max_filiais_coligados | max_funcionarios_coligados_gp | max_meses_servicos | max_meses_servicos_all | max_vl_folha_coligados | max_vl_folha_coligados_gp | media_faturamento_est_coligados | media_faturamento_est_coligados_gp | media_filiais_coligados | media_funcionarios_coligados_gp | media_meses_servicos | media_meses_servicos_all | media_vl_folha_coligados | media_vl_folha_coligados_gp | meses_ultima_contratacaco | min_faturamento_est_coligados | min_faturamento_est_coligados_gp | min_filiais_coligados | min_funcionarios_coligados_gp | min_meses_servicos | min_meses_servicos_all | min_vl_folha_coligados | min_vl_folha_coligados_gp | natureza_juridica_macro | nm_divisao | nm_meso_regiao | nm_micro_regiao | nm_segmento | nu_meses_rescencia | percent_func_genero_fem | percent_func_genero_masc | qt_admitidos | qt_admitidos_12meses | qt_alteracao_socio_180d | qt_alteracao_socio_365d | qt_alteracao_socio_90d | qt_alteracao_socio_total | qt_art | qt_coligadas | qt_coligados | qt_coligados_agropecuaria | qt_coligados_atividade_alto | qt_coligados_atividade_baixo | qt_coligados_atividade_inativo | qt_coligados_atividade_medio | qt_coligados_atividade_mt_baixo | qt_coligados_ativo | qt_coligados_baixada | qt_coligados_ccivil | qt_coligados_centro | qt_coligados_comercio | qt_coligados_epp | qt_coligados_exterior | qt_coligados_inapta | qt_coligados_industria | qt_coligados_ltda | qt_coligados_matriz | qt_coligados_me | qt_coligados_mei | qt_coligados_nordeste | qt_coligados_norte | qt_coligados_nula | qt_coligados_sa | qt_coligados_serviço | qt_coligados_sudeste | qt_coligados_sul | qt_coligados_suspensa | qt_desligados | qt_desligados_12meses | qt_ex_funcionarios | qt_filiais | qt_funcionarios | qt_funcionarios_12meses | qt_funcionarios_24meses | qt_funcionarios_coligados | qt_funcionarios_coligados_gp | qt_funcionarios_grupo | qt_ramos_coligados | qt_regioes_coligados | qt_socios | qt_socios_coligados | qt_socios_feminino | qt_socios_masculino | qt_socios_pep | qt_socios_pf | qt_socios_pj | qt_socios_pj_ativos | qt_socios_pj_baixados | qt_socios_pj_inaptos | qt_socios_pj_nulos | qt_socios_pj_suspensos | qt_socios_st_regular | qt_socios_st_suspensa | qt_ufs_coligados | setor | sg_uf | sg_uf_matriz | sum_faturamento_estimado_coligadas | total | total_filiais_coligados | tx_crescimento_12meses | tx_crescimento_24meses | tx_rotatividade | vl_faturamento_estimado_aux | vl_faturamento_estimado_grupo_aux | vl_folha_coligados | vl_folha_coligados_gp | vl_frota | vl_idade_maxima_socios_pj | vl_idade_media_socios_pj | vl_idade_minima_socios_pj | vl_potenc_cons_oleo_gas | vl_total_tancagem | vl_total_tancagem_grupo | vl_total_veiculos_antt | vl_total_veiculos_antt_grupo | vl_total_veiculos_leves | vl_total_veiculos_leves_grupo | vl_total_veiculos_pesados | vl_total_veiculos_pesados_grupo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 556 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | COMERCIO E REPARACAO DE VEICULOS | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 1660.52 | NaN | NaN | False | False | False | False | True | False | False | False | False | False | NAO | False | False | False | False | False | True | NaN | NaN | 15.0 | 32.0 | 10.0 | 35bbd387f8a4cf454f781fbb75952f7efcadd9dabdfc6b5724fb110c96a74c37 | 4.0 | 1.0 | 3.0 | 8.0 | 8.0 | 5.0 | 4.0 | 9.0 | 13.0 | 2.0 | > 20 | 40.720548 | NaN | 79.0 | NaN | NaN | NaN | 59.500000 | NaN | 40.0 | NaN | NaN | NaN | NaN | 359.066667 | 359.066667 | NaN | NaN | NaN | NaN | NaN | NaN | 123.556140 | 98.280351 | NaN | NaN | 7.666667 | NaN | NaN | NaN | NaN | 7.666667 | 0.766667 | NaN | NaN | ENTIDADES EMPRESARIAIS | COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | OESTE POTIGUAR | MOSSORO | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 23.0 | 15.79 | 84.21 | 95.0 | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 38.0 | 4.0 | 38.0 | 2 | 57.0 | 60.0 | 63.0 | NaN | NaN | 141.0 | NaN | NaN | 2.0 | NaN | NaN | 2.0 | 1.0 | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | NaN | COMERCIO | RN | RN | NaN | 57.0 | NaN | -5.000000 | -9.523810 | 6.837607 | 24212520.0 | 56646990.0 | NaN | NaN | 100694.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4.0 | 16.0 | 1.0 | 1.0 |
| 557 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | CONDOMINIO EDILICIO | ALTA | SERVICOS ADMINISTRATIVOS | ACIMA DE 1 ANO | VERDE | 2007-02-08 | 1149.72 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | True | 1.0 | NaN | 16.0 | 60.0 | 28.0 | 1e36b2c6ecf8630e2f7c02cd759a81ad2e7acc8bf773b1aacf31c7daf3fac711 | 3.0 | 1.0 | 11.0 | 22.0 | 19.0 | 21.0 | 14.0 | 5.0 | 7.0 | 2.0 | 10 a 15 | 11.726027 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 442.266667 | 442.266667 | NaN | NaN | NaN | NaN | NaN | NaN | 76.508254 | 50.578340 | NaN | NaN | 2.200000 | NaN | NaN | NaN | NaN | 2.200000 | -0.366667 | NaN | NaN | ENTIDADES SEM FINS LUCRATIVOS | SERVICOS PARA EDIFICIOS E ATIVIDADES PAISAGISTICAS | LESTE POTIGUAR | NATAL | ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES | 23.0 | 16.19 | 83.81 | 257.0 | 11.0 | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 152.0 | 5.0 | 152.0 | 0 | 105.0 | 99.0 | 119.0 | NaN | NaN | 105.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RN | RN | NaN | 105.0 | NaN | 6.060606 | -11.764706 | 4.901961 | 21327624.0 | 21327624.0 | NaN | NaN | 265726.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 |
| 558 | 634.300000 | NaN | 14.566667 | NaN | DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | BOA | SOCIEDADE ANONIMA ABERTA | ALTA | ELETRICIDADE E GAS | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 1777.60 | 7.780736e+09 | 9.656361e+09 | False | False | False | False | True | False | False | False | False | False | SIM | False | False | False | False | False | True | NaN | NaN | 64.0 | 333.0 | 372.0 | feb26abd3bfc64f12982f55a2368816d6ecb7e008965c2dc02a73dd75dada2bc | 35.0 | 8.0 | 46.0 | 118.0 | 144.0 | 161.0 | 108.0 | 37.0 | 52.0 | 60.0 | > 20 | 52.035616 | 634.300000 | 65.0 | 129.215196 | 129.215196 | NaN | 55.500000 | 14.566667 | 41.0 | 1.999183e+09 | 2.629286e+09 | 135.0 | 3907.0 | 506.433333 | 506.433333 | 313031800.0 | 572342800.0 | 1.144226e+08 | 1.420053e+08 | 8.861111 | 383.071429 | 139.020260 | 166.426737 | 3.307499e+07 | 5.637028e+07 | 2.733333 | 164000.0 | 210000.0 | 1.0 | 1.0 | 2.733333 | -0.066667 | 185457.6 | 61819.2 | ENTIDADES EMPRESARIAIS | ELETRICIDADE GAS E OUTRAS UTILIDADES | LESTE POTIGUAR | NATAL | ELETRICIDADE E GAS | 24.0 | 24.71 | 75.29 | 1421.0 | 51.0 | NaN | NaN | NaN | NaN | 65.0 | 68.0 | 68.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 68.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 48.0 | 0.0 | 68.0 | 0.0 | 0.0 | 6.0 | 0.0 | 0.0 | 56.0 | 18.0 | 62.0 | 0.0 | 0.0 | 651.0 | 90.0 | 649.0 | 29 | 770.0 | 815.0 | 857.0 | 3986.0 | 10726.0 | 788.0 | 14.0 | 2.0 | 13.0 | 164.0 | 2.0 | 8.0 | 9.0 | 11.0 | 2.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 10.0 | NaN | 6.0 | INDUSTRIA | RN | RN | 7.780736e+09 | 769.0 | 319.0 | -5.521472 | -10.151692 | 11.399620 | 500805000.0 | 516073630.0 | 7.937997e+08 | 1.578368e+09 | 9215811.0 | 22.661191 | 21.86037 | 21.059548 | NaN | NaN | NaN | NaN | NaN | 167.0 | 168.0 | 16.0 | 16.0 |
| 559 | 481.033333 | NaN | 99.566667 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | COMERCIO VAREJISTA | ACIMA DE 1 ANO | VERDE | 2005-08-27 | 3071.98 | 8.209219e+06 | 9.349219e+06 | False | False | False | False | True | False | False | False | False | False | SIM | False | False | False | False | False | True | NaN | NaN | 2.0 | 64.0 | 3.0 | 6c0463d509136d232f05962554b6c3e94c04c1627ad9a3441548441e3aee97ed | 1.0 | 1.0 | 3.0 | 15.0 | 11.0 | 14.0 | 7.0 | 7.0 | 8.0 | 2.0 | > 20 | 42.723288 | 481.033333 | 71.0 | 264.744444 | 264.744444 | NaN | 49.666667 | 99.566667 | 37.0 | 7.789219e+06 | 8.719219e+06 | 1.0 | 48.0 | 444.300000 | 5064.700000 | 2596406.5 | 2596406.5 | 2.736406e+06 | 3.116406e+06 | 1.000000 | 24.000000 | 96.749758 | 37.178795 | 2.596406e+06 | 2.596406e+06 | 7.166667 | 210000.0 | 210000.0 | 1.0 | 0.0 | 7.166667 | -0.733333 | 2596406.5 | 2596406.5 | ENTIDADES EMPRESARIAIS | COMERCIO VAREJISTA | CENTRO AMAZONENSE | MANAUS | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 24.0 | 59.42 | 40.58 | 449.0 | 2.0 | NaN | NaN | NaN | NaN | 1.0 | 3.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 380.0 | 7.0 | 380.0 | 9 | 69.0 | 75.0 | 99.0 | 48.0 | 48.0 | 117.0 | 3.0 | 1.0 | 3.0 | 3.0 | 1.0 | 2.0 | NaN | 3.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 3.0 | NaN | 1.0 | COMERCIO | AM | AM | 8.209219e+06 | 69.0 | 2.0 | -8.000000 | -30.303030 | 9.790210 | 21018528.0 | 29660482.0 | 2.596406e+06 | 2.596406e+06 | 294723.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6.0 | 6.0 | 1.0 | 1.0 |
| 560 | 56.200000 | NaN | 56.200000 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS | ACIMA DE 1 ANO | VERDE | 2006-02-01 | NaN | 9.300000e+05 | 9.300000e+05 | False | True | False | False | True | False | False | False | False | True | SIM | False | False | False | False | True | False | NaN | NaN | 150.0 | 127.0 | 2.0 | f3b468c4066fac0d2de28bdafa87ec8b9d103a085cf7de5891b7bafbd7fe7cfc | 34.0 | NaN | 6.0 | 21.0 | 26.0 | 45.0 | 41.0 | 43.0 | 44.0 | 19.0 | 10 a 15 | 12.745205 | 56.200000 | 49.0 | 56.200000 | 56.200000 | NaN | 41.000000 | 56.200000 | 33.0 | 9.300000e+05 | 9.300000e+05 | NaN | NaN | 5099.066667 | 5099.066667 | NaN | NaN | 9.300000e+05 | 9.300000e+05 | NaN | NaN | 173.809677 | 61.097177 | NaN | NaN | 20.733333 | 930000.0 | 930000.0 | NaN | NaN | 24.700000 | -0.566667 | NaN | NaN | ENTIDADES EMPRESARIAIS | SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ANALISES TECNICAS | CENTRO AMAZONENSE | MANAUS | ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS | 23.0 | 63.44 | 36.56 | 981.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 702.0 | 8.0 | 702.0 | 0 | 279.0 | 287.0 | 296.0 | NaN | NaN | 279.0 | 1.0 | 1.0 | 2.0 | 1.0 | NaN | 2.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | SERVIÇO | AM | AM | 9.300000e+05 | 279.0 | NaN | -2.787456 | -5.743243 | 2.826855 | 40955220.0 | 40955220.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 561 | 596.233333 | NaN | 16.700000 | NaN | DE R$ 300.000.000,01 A R$ 500.000.000,00 | DE R$ 500.000.000,01 A 1 BILHAO DE REAIS | BOA | SOCIEDADE ANONIMA FECHADA | ALTA | INDUSTRIA DIGITAL | ACIMA DE 1 ANO | VERDE | 2008-01-14 | 5985.49 | 5.223031e+09 | 5.451955e+09 | False | True | False | False | True | False | False | False | False | True | SIM | True | False | False | False | True | False | NaN | NaN | 140.0 | 2447.0 | 563.0 | 251f454db948590c50df496ea83f76e2227e24a32c2814dd00b363fd77754e29 | 5.0 | 7.0 | 643.0 | 949.0 | 749.0 | 444.0 | 200.0 | 95.0 | 41.0 | 17.0 | 10 a 15 | 10.794521 | 596.233333 | 72.0 | 106.631111 | 106.631111 | NaN | 52.500000 | 16.700000 | 35.0 | 5.150974e+09 | 5.372531e+09 | 275.0 | 1716.0 | 30.333333 | 146.600000 | 171568880.0 | 241816100.0 | 3.482021e+08 | 3.634637e+08 | 24.000000 | 361.600000 | 23.341541 | 18.284345 | 3.669588e+07 | 5.131406e+07 | 3.433333 | 210000.0 | 210000.0 | 1.0 | 10.0 | 3.433333 | -0.466667 | 288489.6 | 288489.6 | ENTIDADES EMPRESARIAIS | ATIVIDADES DE PRESTACAO DE SERVICOS DE INFORMACAO | NORTE MARANHENSE | AGLOMERACAO URBANA DE SAO LUIS | INFORMACAO E COMUNICACAO | 23.0 | 33.56 | 66.44 | 5340.0 | 465.0 | NaN | NaN | NaN | NaN | NaN | 15.0 | 15.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 15.0 | 0.0 | 0.0 | 8.0 | 1.0 | 0.0 | 0.0 | 0.0 | 10.0 | 0.0 | 15.0 | 0.0 | 0.0 | 4.0 | 1.0 | 0.0 | 10.0 | 3.0 | 2.0 | 0.0 | 0.0 | 2168.0 | 394.0 | 2162.0 | 6 | 3172.0 | 3186.0 | 3460.0 | 1229.0 | 1808.0 | 3787.0 | 7.0 | 4.0 | 5.0 | 28.0 | NaN | 4.0 | NaN | 5.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 4.0 | NaN | 5.0 | SERVIÇO | MA | MA | 5.223031e+09 | 3150.0 | 288.0 | -0.439422 | -8.323699 | 12.561773 | 459934850.0 | 560530400.0 | 1.834794e+08 | 2.565703e+08 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 0.0 |
| 562 | 58.266667 | NaN | 58.266667 | NaN | DE R$ 30.000.000,01 A R$ 100.000.000,00 | DE R$ 30.000.000,01 A R$ 100.000.000,00 | NaN | SOCIEDADE EMPRESARIA LIMITADA | ALTA | COMERCIO POR ATACADO | ACIMA DE 1 ANO | VERDE | 2003-04-02 | NaN | 3.770971e+06 | 3.770971e+06 | False | False | False | False | True | False | False | False | False | False | SIM | False | False | False | False | False | True | NaN | NaN | 14.0 | 149.0 | 5.0 | fab2fcabc509768ba2943a21e674fb5af79cb3498730483083054afbb4647cc5 | 7.0 | 5.0 | 13.0 | 19.0 | 21.0 | 35.0 | 29.0 | 17.0 | 12.0 | 10.0 | 15 a 20 | 15.583562 | 58.266667 | 53.0 | 58.266667 | 58.266667 | NaN | 53.000000 | 58.266667 | 53.0 | 3.770971e+06 | 3.770971e+06 | NaN | 21.0 | 182.433333 | 182.433333 | 1256990.4 | 1256990.4 | 3.770971e+06 | 3.770971e+06 | NaN | 21.000000 | 50.483333 | 24.674931 | 1.256990e+06 | 1.256990e+06 | 2.233333 | 3770971.2 | 3770971.2 | NaN | 21.0 | 2.233333 | -0.666667 | 1256990.4 | 1256990.4 | ENTIDADES EMPRESARIAIS | COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS | CENTRO AMAZONENSE | MANAUS | COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS | 23.0 | 13.69 | 86.31 | 606.0 | 44.0 | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 436.0 | 42.0 | 436.0 | 0 | 170.0 | 173.0 | 177.0 | 21.0 | 21.0 | 168.0 | 1.0 | 1.0 | 2.0 | 1.0 | NaN | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | 1.0 | COMERCIO | AM | AM | 3.770971e+06 | 168.0 | NaN | -1.734104 | -3.954802 | 24.852071 | 53164510.0 | 53164510.0 | 1.256990e+06 | 1.256990e+06 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | 18.0 | 18.0 |
| 563 | 536.733333 | NaN | 346.366667 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | BENS DE CONSUMO | ACIMA DE 1 ANO | AZUL | 2005-11-03 | 814.85 | 8.281920e+05 | 1.248192e+06 | False | True | False | False | True | False | False | False | False | False | SIM | False | False | False | False | True | True | NaN | NaN | 14.0 | 104.0 | 9.0 | 564fde999c34d33a262dad0e1596029b2b5f92e4f0aed68dc1e8d47020bf9c61 | 5.0 | 1.0 | 10.0 | 23.0 | 27.0 | 15.0 | 17.0 | 14.0 | 5.0 | 10.0 | > 20 | 23.698630 | 536.733333 | 60.0 | 441.550000 | 441.550000 | NaN | 58.500000 | 346.366667 | 57.0 | 6.181920e+05 | 8.281920e+05 | 1.0 | 4.0 | 443.033333 | 443.033333 | 247276.8 | 247276.8 | 4.140960e+05 | 6.240960e+05 | 1.000000 | 4.000000 | 87.902100 | 51.202656 | 2.472768e+05 | 2.472768e+05 | 2.266667 | 210000.0 | 420000.0 | 1.0 | 4.0 | 2.266667 | -0.433333 | 247276.8 | 247276.8 | ENTIDADES EMPRESARIAIS | FABRICACAO DE PRODUTOS ALIMENTICIOS | LESTE POTIGUAR | NATAL | INDUSTRIAS DE TRANSFORMACAO | 23.0 | 22.83 | 77.17 | 365.0 | 34.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 238.0 | 19.0 | 237.0 | 0 | 127.0 | 112.0 | 153.0 | 4.0 | 4.0 | 127.0 | 2.0 | 1.0 | 2.0 | 2.0 | 1.0 | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 1.0 | INDUSTRIA | RN | RN | 8.281920e+05 | 127.0 | 2.0 | 13.392857 | -16.993464 | 15.899582 | 27658940.0 | 27658940.0 | 2.472768e+05 | 2.472768e+05 | 72226.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2.0 | 2.0 | 2.0 | 2.0 |
| 564 | NaN | NaN | NaN | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 100.000.000,01 A R$ 300.000.000,00 | NaN | SERVICO SOCIAL AUTONOMO | ALTA | SERVICOS DE EDUCACAO | ACIMA DE 1 ANO | VERDE | 2000-04-03 | 2323.03 | NaN | NaN | False | True | False | False | True | False | False | False | False | True | NAO | False | False | False | False | True | True | NaN | NaN | 3.0 | 16.0 | 73.0 | 31438f752b4a846638c0acd98c3078d7e1ee83204e0388bb15a61f38b358216c | 2.0 | NaN | 1.0 | 8.0 | 18.0 | 17.0 | 19.0 | 16.0 | 5.0 | 6.0 | 15 a 20 | 18.580822 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 300.466667 | 373.766667 | NaN | NaN | NaN | NaN | NaN | NaN | 69.311232 | 54.917612 | NaN | NaN | 2.066667 | NaN | NaN | NaN | NaN | 2.066667 | -0.433333 | NaN | NaN | ENTIDADES SEM FINS LUCRATIVOS | EDUCACAO | NaN | NaN | EDUCACAO | 23.0 | 59.78 | 40.22 | 388.0 | 5.0 | NaN | NaN | NaN | NaN | 4.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 296.0 | 30.0 | 296.0 | 10 | 92.0 | 118.0 | 132.0 | NaN | NaN | 482.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SERVIÇO | RO | RO | NaN | 92.0 | NaN | -22.033898 | -30.303030 | 28.708134 | 26530740.0 | 108877850.0 | NaN | NaN | 1603418.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 17.0 | 19.0 | 2.0 | 2.0 |
| 565 | 323.066667 | NaN | 74.166667 | NaN | DE R$ 10.000.000,01 A R$ 30.000.000,00 | DE R$ 10.000.000,01 A R$ 30.000.000,00 | BOA | SOCIEDADE EMPRESARIA LIMITADA | ALTA | INDUSTRIA DA CONSTRUCAO | ACIMA DE 1 ANO | VERDE | 2005-11-03 | 4315.60 | 6.189792e+06 | 6.609792e+06 | False | False | False | False | True | False | False | False | False | True | SIM | False | False | False | False | False | True | 1.0 | NaN | 69.0 | 65.0 | 2.0 | 8a226339b331b5aec24877a69edc40070b9dd7e71b21943996db577948efaf69 | 4.0 | NaN | 14.0 | 20.0 | 23.0 | 20.0 | 22.0 | 11.0 | 14.0 | 9.0 | > 20 | 41.164384 | 323.066667 | 68.0 | 191.375000 | 191.375000 | NaN | 66.500000 | 74.166667 | 65.0 | 5.563728e+06 | 5.773728e+06 | 1.0 | 45.0 | 258.033333 | 258.033333 | 2781864.0 | 2781864.0 | 1.547448e+06 | 1.652448e+06 | 1.000000 | 12.000000 | 36.168613 | 11.335941 | 1.442448e+06 | 1.442448e+06 | 4.866667 | 206064.0 | 210000.0 | 1.0 | 0.0 | 4.866667 | -5.566667 | 103032.0 | 103032.0 | ENTIDADES EMPRESARIAIS | CONSTRUCAO DE EDIFICIOS | CENTRO NORTE PIAUIENSE | TERESINA | CONSTRUCAO | 23.0 | 5.11 | 94.89 | 1844.0 | 14.0 | NaN | NaN | NaN | NaN | 2.0 | 4.0 | 4.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4.0 | 0.0 | 0.0 | 4.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 0.0 | 0.0 | 1707.0 | 5.0 | 1706.0 | 6 | 137.0 | 128.0 | 511.0 | 48.0 | 48.0 | 137.0 | 3.0 | 1.0 | 2.0 | 4.0 | 1.0 | 1.0 | NaN | 2.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | 2.0 | NaN | 2.0 | CONSTRUÇÃO CIVIL | PI | PI | 6.189792e+06 | 137.0 | 2.0 | 7.031250 | -73.189824 | 3.773585 | 19782144.0 | 22572144.0 | 2.884896e+06 | 2.884896e+06 | 100470.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | 1.0 | 0.0 | 0.0 |